APPS.POGOT_S dependencies on PO_LINE_LOCATIONS_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 567: FROM PO_LINE_LOCATIONS_ALL PLL,

563: ) * nvl(PLL.price_override, 0) /
564: C.minimum_accountable_unit
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

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 650: FROM PO_LINE_LOCATIONS_ALL PLL,

646: ) * nvl(PLL.price_override, 0) /
647: C.minimum_accountable_unit
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

Line 726: FROM PO_LINE_LOCATIONS_ALL PLL,

722: * nvl(PLL.price_override,0) /
723: C.minimum_accountable_unit) *
724: C.minimum_accountable_unit)), 0)
725: INTO x_result_fld
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

Line 727: PO_LINE_LOCATIONS_ALL PLL2,

723: C.minimum_accountable_unit) *
724: C.minimum_accountable_unit)), 0)
725: INTO x_result_fld
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

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:

Line 804: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,

800: round ((POL.quantity - nvl(POL.quantity_cancelled, 0))
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

Line 824: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,

820: * nvl(POL.price_override, 0) /
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

Line 842: FROM PO_LINE_LOCATIONS_ALL POL, PO_HEADERS_ALL POH,

838: * nvl(POL.price_override, 0) /
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;