APPS.PO_SERVICES_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 738: po_distributions_all POD

734:
735: SELECT count(*)
736: INTO l_count_services_lines
737: FROM po_lines_all POL,
738: po_distributions_all POD
739: WHERE POL.po_header_id = p_po_header_id
740: AND POL.order_type_lookup_code IN ('FIXED PRICE', 'RATE')
741: AND POD.po_line_id = POL.po_line_id -- Join between PO Lines and Distributions
742: AND POD.req_distribution_id IS NOT NULL; -- There exists a backing Req

Line 797: po_distributions_all POD

793:
794: SELECT count(*)
795: INTO l_count
796: FROM po_lines_all POL,
797: po_distributions_all POD
798: WHERE POL.po_line_id = p_po_line_id
799: AND POL.order_type_lookup_code = 'FIXED PRICE'
800: AND POL.purchase_basis = 'SERVICES'
801: AND POD.po_line_id = POL.po_line_id

Line 859: po_distributions_all POD

855: SELECT count(*)
856: INTO l_count
857: FROM po_line_locations_all POLL,
858: po_lines_all POL,
859: po_distributions_all POD
860: WHERE POLL.line_location_id = p_po_line_location_id
861: AND POL.po_line_id = POLL.po_line_id
862: AND POL.order_type_lookup_code = 'FIXED PRICE'
863: AND POL.purchase_basis = 'SERVICES'