DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on PO_REQ_DISTRIBUTIONS_ALL

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

1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(2) '||l_source_distribution_id_num_1);
1887: END;
1888: ELSIF (l_source_distribution_type ='PO_REQ_DISTRIBUTIONS_ALL') THEN
1889: l_reference_1 := 'REQ';
1890: l_reference_3 := l_source_distribution_id_num_1;
1891: BEGIN
1892: --Modified for bug 7253838

Line 1899: FROM po_req_distributions_all pod,

1895: SELECT poh.requisition_header_id
1896: --, poh.segment1
1897: INTO l_reference_2
1898: --, l_reference_4
1899: FROM po_req_distributions_all pod,
1900: po_requisition_headers_all poh,
1901: po_requisition_lines_all pol
1902: WHERE pod.distribution_id = l_source_distribution_id_num_1
1903: AND pol.requisition_header_id = poh.requisition_header_id

Line 1926: FROM po_req_distributions_all pod,

1922: SELECT poh.requisition_header_id,
1923: poh.segment1
1924: INTO l_reference_2,
1925: l_reference_4
1926: FROM po_req_distributions_all pod,
1927: po_requisition_headers_all poh,
1928: po_requisition_lines_all pol
1929: WHERE pod.distribution_id = l_source_distribution_id_num_1
1930: AND pol.requisition_header_id = poh.requisition_header_id