APPS.POGOT_S dependencies on STANDARD

Line 135: AND PLL.shipment_type in ('STANDARD','PLANNED', 'BLANKET')

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:
138: end if; /* x_base_currency <> x_po_currency */
139:

Line 163: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');

159: FND_CURRENCIES C
160: WHERE PLL.po_header_id = x_object_id
161: AND PH.po_header_id = PLL.po_header_id
162: AND PH.currency_code = C.currency_code
163: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');
164:
165: end if;
166:
167: elsif (x_object_type = 'P') then /* For PO Planned */

Line 325: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET','SCHEDULED')

321: WHERE PH.po_header_id = x_object_id
322: AND PH.segment1 = PL.contract_num
323: AND PH.currency_code = C.currency_code
324: AND PL.po_line_id = PLL.po_line_id
325: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET','SCHEDULED')
326: AND PLL.line_location_id = PLL2.source_shipment_id (+)
327: GROUP BY C.minimum_accountable_unit, C.precision,
328: PLL.quantity, PLL.quantity_cancelled,
329: PLL.price_override, PLL.line_location_id;

Line 419: AND POL.shipment_type in ('STANDARD','PLANNED','BLANKET');

415: FND_CURRENCIES C
416: WHERE POL.po_line_id = x_object_id
417: AND POH.po_header_id = POL.po_header_id
418: AND POH.currency_code = C.currency_code
419: AND POL.shipment_type in ('STANDARD','PLANNED','BLANKET');
420:
421: elsif (x_object_type = 'S' ) then /* PO Shipment */
422: x_progress := 240;
423: SELECT

Line 545: AND PLL.shipment_type in ('STANDARD','PLANNED', 'BLANKET')

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:
548: end if; /* x_base_currency <> x_po_currency_1 */
549:

Line 573: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');

569: FND_CURRENCIES C
570: WHERE PLL.po_header_id = x_object_id
571: AND PH.po_header_id = PLL.po_header_id
572: AND PH.currency_code = C.currency_code
573: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET');
574:
575: end if;
576:
577: elsif (x_object_type = 'P') then /* For PO Planned */

Line 735: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET','SCHEDULED')

731: WHERE PH.po_header_id = x_object_id
732: AND PH.segment1 = PL.contract_num
733: AND PH.currency_code = C.currency_code
734: AND PL.po_line_id = PLL.po_line_id
735: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET','SCHEDULED')
736: AND PLL.line_location_id = PLL2.source_shipment_id (+)
737: GROUP BY C.minimum_accountable_unit, C.precision,
738: PLL.quantity, PLL.quantity_cancelled,
739: PLL.price_override, PLL.line_location_id;

Line 829: AND POL.shipment_type in ('STANDARD','PLANNED','BLANKET');

825: FND_CURRENCIES C
826: WHERE POL.po_line_id = x_object_id
827: AND POH.po_header_id = POL.po_header_id
828: AND POH.currency_code = C.currency_code
829: AND POL.shipment_type in ('STANDARD','PLANNED','BLANKET');
830:
831: elsif (x_object_type = 'S' ) then /* PO Shipment */
832: x_progress := 240;
833: SELECT