APPS.ONT_OEXOEORD_XMLP_PKG dependencies on OE_ORDER_HEADERS

Line 491: OE_ORDER_HEADERS OH2

487: SELECT
488: OH2.ORDER_NUMBER
489: INTO REF_NUMBER
490: FROM
491: OE_ORDER_HEADERS OH2
492: WHERE OH2.HEADER_ID = REF_ID;
493: ELSIF (REF_TYPE_CODE = 'PO') THEN
494: SELECT
495: OH2.CUST_PO_NUMBER

Line 498: OE_ORDER_HEADERS OH2

494: SELECT
495: OH2.CUST_PO_NUMBER
496: INTO REF_NUMBER
497: FROM
498: OE_ORDER_HEADERS OH2
499: WHERE OH2.HEADER_ID = REF_ID;
500: END IF;
501: END IF;
502: RETURN (REF_NUMBER);