eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POGOT_S dependencies on PO_LINE_LOCATIONS

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 157: FROM PO_LINE_LOCATIONS PLL,

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

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 240: FROM PO_LINE_LOCATIONS PLL,

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

Line 316: FROM PO_LINE_LOCATIONS PLL,

312: * nvl(PLL.price_override,0) /
313: C.minimum_accountable_unit) *
314: C.minimum_accountable_unit)), 0)
315: INTO x_result_fld
316: FROM PO_LINE_LOCATIONS PLL,
317: PO_LINE_LOCATIONS PLL2,
318: PO_LINES PL,
319: PO_HEADERS PH,
320: FND_CURRENCIES C

Line 317: PO_LINE_LOCATIONS PLL2,

313: C.minimum_accountable_unit) *
314: C.minimum_accountable_unit)), 0)
315: INTO x_result_fld
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

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 394: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,

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

Line 414: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,

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

Line 432: FROM PO_LINE_LOCATIONS POL, PO_HEADERS POH,

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

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;