APPS.POGOT_S dependencies on PO_HEADERS_ALL

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;