eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS_TRX_REGISTER dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1819: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN

1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(2) '||l_source_distribution_id_num_1);
1818: END;
1819: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN
1820: l_reference_1 := 'REQ';
1821: l_reference_3 := l_source_distribution_id_num_1;
1822: BEGIN
1823: SELECT poh.requisition_header_id,

Line 1827: FROM po_req_distributions_all pod,

1823: SELECT poh.requisition_header_id,
1824: poh.segment1
1825: INTO l_reference_2,
1826: l_reference_4
1827: FROM po_req_distributions_all pod,
1828: po_requisition_headers_all poh,
1829: po_requisition_lines_all pol
1830: WHERE pod.distribution_id = l_source_distribution_id_num_1
1831: AND pol.requisition_header_id = poh.requisition_header_id

Line 1846: FROM po_req_distributions_all pod,

1842: SELECT poh.requisition_header_id,
1843: poh.segment1
1844: INTO l_reference_2,
1845: l_reference_4
1846: FROM po_req_distributions_all pod,
1847: po_requisition_headers_all poh,
1848: po_requisition_lines_all pol
1849: WHERE pod.distribution_id = l_source_distribution_id_num_1
1850: AND pol.requisition_header_id = poh.requisition_header_id