How to Reverse the distribution Lines when entered wrongly

Reverse the distribution Lines when entered wrongly

Responsibility: GL Super User
Nav: Setup > Financials > Flexfields > Key > Security > Assign
Pull up COMPANY rule
Delete row for INR STAT AP Manager

Query to find on which Patch level we are for particular module

Query to find on which Patch level we are for particular module

select * from fnd_application
where APPLICATION_SHORT_NAME='PA'


select * from FND_PRODUCT_INSTALLATIONS
where APPLICATION_ID=275

Can cross check the PATCH_LEVEL column.

To Track Requisition Number from PO Number

If we have PO Number then use below query to get the Related Requisition Number

SELECT segment1
FROM po_requisition_headers_all
WHERE requisition_header_id IN
(SELECT requisition_header_id
FROM po_requisition_lines_all
WHERE requisition_line_id IN
(SELECT requisition_line_id
FROM po_req_distributions_all
WHERE distribution_id IN
(SELECT req_distribution_id
FROM po_distributions_all
WHERE po_header_id IN
(SELECT po_header_id
FROM po_headers_all
WHERE segment1 = Give Po Number)
)
)
)
;