APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 475: OE_ORDER_HEADERS_ALL OH

471: ,50) CUSTOMER_NAME
472: FROM
473: HZ_PARTIES PARTY,
474: HZ_CUST_ACCOUNTS CUST_ACCT,
475: OE_ORDER_HEADERS_ALL OH
476: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
477: AND OH.HEADER_ID = O_ID
478: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
479: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';

Line 503: OE_ORDER_HEADERS_ALL OH

499: ,50) CUSTOMER_NAME
500: FROM
501: HZ_PARTIES PARTY,
502: HZ_CUST_ACCOUNTS CUST_ACCT,
503: OE_ORDER_HEADERS_ALL OH
504: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
505: AND OH.HEADER_ID = O_ID
506: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
507: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';

Line 767: OE_ORDER_HEADERS_ALL

763: CURSOR REQUISITION(X_ORDER_HEADER IN NUMBER) IS
764: SELECT
765: ORIG_SYS_DOCUMENT_REF
766: FROM
767: OE_ORDER_HEADERS_ALL
768: WHERE HEADER_ID = X_ORDER_HEADER
769: AND SOURCE_DOCUMENT_TYPE_ID = 10;
770: REQN_NUMBER OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF%TYPE := ' ';
771: BEGIN

Line 770: REQN_NUMBER OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF%TYPE := ' ';

766: FROM
767: OE_ORDER_HEADERS_ALL
768: WHERE HEADER_ID = X_ORDER_HEADER
769: AND SOURCE_DOCUMENT_TYPE_ID = 10;
770: REQN_NUMBER OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF%TYPE := ' ';
771: BEGIN
772: OPEN REQUISITION(SOURCE_HEADER_ID);
773: FETCH REQUISITION
774: INTO REQN_NUMBER;