APPS.PO_POAPPROVAL_INIT1 dependencies on PO_DISTRIBUTIONS_ALL

Line 634: FROM po_distributions_all POD

630: ) / X_min_acct_unit
631: ) * X_min_acct_unit
632: ),0)
633: INTO l_tax_amount
634: FROM po_distributions_all POD
635: WHERE po_header_id = POHdr_rec.po_header_id;
636: ELSE
637: SELECT nvl(sum( round (POD.nonrecoverable_tax *
638: decode(quantity_ordered,

Line 647: FROM po_distributions_all POD

643: X_precision
644: )
645: ),0)
646: INTO l_tax_amount
647: FROM po_distributions_all POD
648: WHERE po_header_id = POHdr_rec.po_header_id;
649: END IF;
650:
651: /*End Bug# 3972475 */

Line 932: FROM po_distributions_all POD

928: ) / X_min_acct_unit
929: ) * X_min_acct_unit
930: ),0)
931: INTO l_tax_amount
932: FROM po_distributions_all POD
933: WHERE po_release_id = RelHdr_rec.po_release_id;
934: ELSE
935: SELECT nvl(sum( round (POD.nonrecoverable_tax *
936: decode(quantity_ordered,

Line 945: FROM po_distributions_all POD

941: X_precision
942: )
943: ),0)
944: INTO l_tax_amount
945: FROM po_distributions_all POD
946: WHERE po_release_id = RelHdr_rec.po_release_id;
947: END IF;
948:
949: /*End Bug# 3972475 */

Line 1300: -- Changed po_distributions to po_distributions_all to only have a single

1296: -- : Added join to po_line_locations and shipment_num
1297: -- to the ORDER BY clause so we will get the first distribution on the
1298: -- first pay item that has a deliver-to-person, in the case of a complex
1299: -- work PO that has multiple pay items on a fixed-price temp labor line.
1300: -- Changed po_distributions to po_distributions_all to only have a single
1301: -- secured synonym in the query.
1302: SELECT POD.deliver_to_person_id
1303: FROM po_distributions_all POD
1304: , po_line_locations PLL --

Line 1303: FROM po_distributions_all POD

1299: -- work PO that has multiple pay items on a fixed-price temp labor line.
1300: -- Changed po_distributions to po_distributions_all to only have a single
1301: -- secured synonym in the query.
1302: SELECT POD.deliver_to_person_id
1303: FROM po_distributions_all POD
1304: , po_line_locations PLL --
1305: WHERE POD.line_location_id = PLL.line_location_id
1306: AND PLL.po_line_id = p_po_line_id
1307: AND POD.deliver_to_person_id IS NOT NULL