APPS.POGOT_S dependencies on PO_DISTRIBUTIONS_ALL

Line 543: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

539: nvl(PLL.price_override, 0) / x_min_unit) *
540: x_min_unit) * POD.rate / x_base_min_unit) *
541: x_base_min_unit)), 0)
542: INTO x_result_fld
543: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
544: WHERE PLL.po_header_id = x_object_id
545: AND PLL.shipment_type in ('STANDARD','PLANNED', 'BLANKET')
546: AND PLL.line_location_id = POD.line_location_id;
547:

Line 626: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

622: nvl(PLL.price_override, 0) / x_min_unit) *
623: x_min_unit) * POD.rate / x_base_min_unit) *
624: x_base_min_unit)), 0)
625: INTO x_result_fld
626: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
627: WHERE PLL.po_header_id = x_object_id
628: AND PLL.shipment_type = 'SCHEDULED'
629: AND PLL.line_location_id = POD.line_location_id;
630:

Line 788: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

784: nvl(PLL.price_override, 0) / x_min_unit)
785: ) * x_min_unit) * POD.rate) / x_base_min_unit
786: ) * x_base_min_unit)), 0)
787: INTO x_result_fld
788: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
789: WHERE PLL.po_release_id = x_object_id
790: AND PLL.line_location_id = POD.line_location_id
791: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
792: