DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 476: OE_ORDER_HEADERS_ALL OH

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

Line 504: OE_ORDER_HEADERS_ALL OH

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

Line 768: OE_ORDER_HEADERS_ALL

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

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

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