DBA Data[Home] [Help]

APPS.WMS_WMSSTCON_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 114: HZ_CUST_ACCOUNTS CUST_ACCT

110: PARTY.PARTY_NUMBER
111: INTO P_CUSTOMER_NAME,P_CUSTOMER_NUMBER
112: FROM
113: HZ_PARTIES PARTY,
114: HZ_CUST_ACCOUNTS CUST_ACCT
115: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_ID
116: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;
117: END IF;
118: IF P_SALES_ORDER_HEADER_ID IS NOT NULL THEN

Line 132: HZ_CUST_ACCOUNTS CUST_ACCT,

128: PARTY.PARTY_NUMBER
129: INTO P_CUSTOMER_NAME,P_CUSTOMER_NUMBER
130: FROM
131: HZ_PARTIES PARTY,
132: HZ_CUST_ACCOUNTS CUST_ACCT,
133: OE_ORDER_HEADERS_ALL OEH
134: WHERE CUST_ACCT.CUST_ACCOUNT_ID = OEH.SOLD_TO_ORG_ID
135: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
136: AND OEH.HEADER_ID = P_SALES_ORDER_HEADER_ID;