DBA Data[Home] [Help]

APPS.WMS_WMSSTCON_XMLP_PKG dependencies on HZ_PARTIES

Line 113: HZ_PARTIES PARTY,

109: PARTY.PARTY_NAME,
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;

Line 131: HZ_PARTIES PARTY,

127: PARTY.PARTY_NAME,
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