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_HEADERS

Line 36: FROM PO_HEADERS POH,

32: SELECT GSB.currency_code,
33: POH.currency_code
34: INTO x_base_currency,
35: x_po_currency
36: FROM PO_HEADERS POH,
37: FINANCIALS_SYSTEM_PARAMETERS FSP,
38: GL_SETS_OF_BOOKS GSB
39: WHERE POH.po_header_id = x_object_id
40: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 158: PO_HEADERS PH,

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
162: AND PH.currency_code = C.currency_code

Line 241: PO_HEADERS PH,

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
245: AND PH.currency_code = C.currency_code

Line 319: PO_HEADERS PH,

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
322: AND PH.segment1 = PL.contract_num
323: AND PH.currency_code = C.currency_code

Line 339: FROM PO_HEADERS POH,

335: SELECT GSB.currency_code,
336: POH.currency_code
337: INTO x_base_currency,
338: x_po_currency
339: FROM PO_HEADERS POH,
340: FINANCIALS_SYSTEM_PARAMETERS FSP,
341: GL_SETS_OF_BOOKS GSB,
342: PO_RELEASES POR
343: WHERE POH.po_header_id = POR.po_header_id

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 463: FROM PO_HEADERS_ALL POH,

459: SELECT GSB.currency_code,
460: POH.currency_code
461: INTO x_base_currency,
462: x_po_currency
463: FROM PO_HEADERS_ALL POH,
464: FINANCIALS_SYSTEM_PARAMETERS FSP,
465: GL_SETS_OF_BOOKS GSB
466: WHERE POH.po_header_id = x_object_id
467: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 568: PO_HEADERS_ALL PH,

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
572: AND PH.currency_code = C.currency_code

Line 651: PO_HEADERS_ALL PH,

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
655: AND PH.currency_code = C.currency_code

Line 729: PO_HEADERS_ALL PH,

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
732: AND PH.segment1 = PL.contract_num
733: AND PH.currency_code = C.currency_code

Line 749: FROM PO_HEADERS_ALL POH,

745: SELECT GSB.currency_code,
746: POH.currency_code
747: INTO x_base_currency,
748: x_po_currency_1
749: FROM PO_HEADERS_ALL POH,
750: FINANCIALS_SYSTEM_PARAMETERS FSP,
751: GL_SETS_OF_BOOKS GSB,
752: PO_RELEASES_ALL POR
753: WHERE POH.po_header_id = POR.po_header_id

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;