APPS.POGOT_S dependencies on PO_DISTRIBUTIONS

Line 133: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL

129: nvl(PLL.price_override, 0) / x_min_unit) *
130: x_min_unit) * POD.rate / x_base_min_unit) *
131: x_base_min_unit)), 0)
132: INTO x_result_fld
133: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL
134: WHERE PLL.po_header_id = x_object_id
135: AND PLL.shipment_type in ('STANDARD','PLANNED', 'BLANKET')
136: AND PLL.line_location_id = POD.line_location_id;
137:

Line 216: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL

212: nvl(PLL.price_override, 0) / x_min_unit) *
213: x_min_unit) * POD.rate / x_base_min_unit) *
214: x_base_min_unit)), 0)
215: INTO x_result_fld
216: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL
217: WHERE PLL.po_header_id = x_object_id
218: AND PLL.shipment_type = 'SCHEDULED'
219: AND PLL.line_location_id = POD.line_location_id;
220:

Line 378: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL

374: nvl(PLL.price_override, 0) / x_min_unit)
375: ) * x_min_unit) * POD.rate) / x_base_min_unit
376: ) * x_base_min_unit)), 0)
377: INTO x_result_fld
378: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL
379: WHERE PLL.po_release_id = x_object_id
380: AND PLL.line_location_id = POD.line_location_id
381: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
382:

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: