APPS.PO_POAPPROVAL_INIT1 dependencies on PO_DISTRIBUTIONS_ALL

Line 775: FROM po_distributions_all POD,

771: ) / X_min_acct_unit
772: ) * X_min_acct_unit
773: ),0)
774: INTO l_tax_amount
775: FROM po_distributions_all POD,
776: po_line_locations_all POLL
777: WHERE POD.po_header_id = POHdr_rec.po_header_id
778: AND POD.line_location_id=POLL.line_location_id
779: AND POD.po_header_id=POLL.po_header_id

Line 800: FROM po_distributions_all POD,

796: X_precision
797: )
798: ),0)
799: INTO l_tax_amount
800: FROM po_distributions_all POD,
801: po_line_locations_all POLL
802: WHERE POD.po_header_id = POHdr_rec.po_header_id
803: AND POD.line_location_id=POLL.line_location_id
804: AND POD.po_header_id=POLL.po_header_id

Line 1161: FROM po_distributions_all POD

1157: ) / X_min_acct_unit
1158: ) * X_min_acct_unit
1159: ),0)
1160: INTO l_tax_amount
1161: FROM po_distributions_all POD
1162: WHERE po_release_id = RelHdr_rec.po_release_id;
1163: ELSE
1164: SELECT nvl(sum( round (POD.nonrecoverable_tax *
1165: decode(quantity_ordered,

Line 1175: FROM po_distributions_all POD

1171: X_precision
1172: )
1173: ),0)
1174: INTO l_tax_amount
1175: FROM po_distributions_all POD
1176: WHERE po_release_id = RelHdr_rec.po_release_id;
1177: END IF;
1178:
1179: /*End Bug# 3972475 */

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

1528: -- : Added join to po_line_locations and shipment_num
1529: -- to the ORDER BY clause so we will get the first distribution on the
1530: -- first pay item that has a deliver-to-person, in the case of a complex
1531: -- work PO that has multiple pay items on a fixed-price temp labor line.
1532: -- Changed po_distributions to po_distributions_all to only have a single
1533: -- secured synonym in the query.
1534: SELECT POD.deliver_to_person_id
1535: FROM po_distributions_all POD
1536: , po_line_locations PLL --

Line 1535: FROM po_distributions_all POD

1531: -- work PO that has multiple pay items on a fixed-price temp labor line.
1532: -- Changed po_distributions to po_distributions_all to only have a single
1533: -- secured synonym in the query.
1534: SELECT POD.deliver_to_person_id
1535: FROM po_distributions_all POD
1536: , po_line_locations PLL --
1537: WHERE POD.line_location_id = PLL.line_location_id
1538: AND PLL.po_line_id = p_po_line_id
1539: AND POD.deliver_to_person_id IS NOT NULL