[Home] [Help]
155: ) * C.minimum_accountable_unit))
156: INTO x_result_fld
157: FROM PO_LINE_LOCATIONS PLL,
158: PO_HEADERS PH,
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');
238: ) * C.minimum_accountable_unit))
239: INTO x_result_fld
240: FROM PO_LINE_LOCATIONS PLL,
241: PO_HEADERS PH,
242: FND_CURRENCIES C
243: WHERE PLL.po_header_id = x_object_id
244: AND PH.po_header_id = PLL.po_header_id
245: AND PH.currency_code = C.currency_code
246: AND PLL.shipment_type = 'SCHEDULED';
316: FROM PO_LINE_LOCATIONS PLL,
317: PO_LINE_LOCATIONS PLL2,
318: PO_LINES PL,
319: PO_HEADERS PH,
320: FND_CURRENCIES C
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
391: * nvl(POL.price_override, 0) /
392: C.minimum_accountable_unit) * C.minimum_accountable_unit))
393: INTO x_result_fld
394: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,
395: FND_CURRENCIES C
396: WHERE POL.po_release_id = x_object_id
397: AND POH.po_header_id = POL.po_header_id
398: AND POH.currency_code = C.currency_code
399: AND POL.shipment_type in ('SCHEDULED','BLANKET');
411: C.minimum_accountable_unit)
412: * C.minimum_accountable_unit))
413: INTO x_result_fld
414: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,
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');
429: C.minimum_accountable_unit)
430: * C.minimum_accountable_unit))
431: INTO x_result_fld
432: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,
433: FND_CURRENCIES C
434: WHERE line_location_id = x_object_id
435: AND POH.po_header_id = POL.po_header_id
436: AND POH.currency_code = C.currency_code;
437:
565: ) * C.minimum_accountable_unit))
566: INTO x_result_fld
567: FROM PO_LINE_LOCATIONS_ALL PLL,
568: PO_HEADERS_ALL PH,
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');
648: ) * C.minimum_accountable_unit))
649: INTO x_result_fld
650: FROM PO_LINE_LOCATIONS_ALL PLL,
651: PO_HEADERS_ALL PH,
652: FND_CURRENCIES C
653: WHERE PLL.po_header_id = x_object_id
654: AND PH.po_header_id = PLL.po_header_id
655: AND PH.currency_code = C.currency_code
656: AND PLL.shipment_type = 'SCHEDULED';
726: FROM PO_LINE_LOCATIONS_ALL PLL,
727: PO_LINE_LOCATIONS_ALL PLL2,
728: PO_LINES_ALL PL,
729: PO_HEADERS_ALL PH,
730: FND_CURRENCIES C
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
801: * nvl(POL.price_override, 0) /
802: C.minimum_accountable_unit) * C.minimum_accountable_unit))
803: INTO x_result_fld
804: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,
805: FND_CURRENCIES C
806: WHERE POL.po_release_id = x_object_id
807: AND POH.po_header_id = POL.po_header_id
808: AND POH.currency_code = C.currency_code
809: AND POL.shipment_type in ('SCHEDULED','BLANKET');
821: C.minimum_accountable_unit)
822: * C.minimum_accountable_unit))
823: INTO x_result_fld
824: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,
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');
839: C.minimum_accountable_unit)
840: * C.minimum_accountable_unit))
841: INTO x_result_fld
842: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,
843: FND_CURRENCIES C
844: WHERE line_location_id = x_object_id
845: AND POH.po_header_id = POL.po_header_id
846: AND POH.currency_code = C.currency_code;
847: