DBA Data[Home] [Help]

APPS.JG_JGZZRCAK_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 83: HZ_CUST_ACCOUNTS HCA

79: MAX(HP.PARTY_NAME)
80: FROM
81: AR_CASH_RECEIPTS ACR,
82: HZ_PARTIES HP,
83: HZ_CUST_ACCOUNTS HCA
84: WHERE ( ACR.GLOBAL_ATTRIBUTE1 is NULL
85: AND ACR.GLOBAL_ATTRIBUTE2 is NULL )
86: AND HP.PARTY_ID = HCA.PARTY_ID
87: AND HCA.CUST_ACCOUNT_ID = ACR.PAY_FROM_CUSTOMER;

Line 303: HZ_CUST_ACCOUNTS HCA,

299: CR.CURRENCY_CODE,
300: HCSU.SITE_USE_ID
301: FROM
302: HZ_PARTIES HP,
303: HZ_CUST_ACCOUNTS HCA,
304: HZ_CUST_SITE_USES HCSU,
305: HZ_LOCATIONS HL,
306: HZ_CUST_ACCT_SITES HCAS,
307: AR_CASH_RECEIPTS CR,