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
1832: AND pod.requisition_line_id = pol.requisition_line_id;
1833: EXCEPTION
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
1851: AND pod.requisition_line_id = pol.requisition_line_id;
1852: EXCEPTION