APPS.FV_SF1080_TRANSACTION dependencies on HZ_CUST_ACCOUNTS

Line 258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp

254: hzl.state cust_state,
255: hzl.postal_code cust_postal_code
256: FROM RA_CUSTOMER_TRX rct,
257: hz_locations hzl, hz_cust_acct_sites hzcas,
258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp
259: WHERE rct.set_of_books_id = parm_set_of_books_id
260: AND rct.bill_to_customer_id = hzca.cust_account_id
261: AND hzca.cust_Account_id = hzcas.cust_account_id
262: AND hzp.party_id = hzca.party_id

Line 292: FROM hz_cust_accounts hzca

288: parm_print_date_low)
289: AND DECODE(parm_print_date_high,null,trunc(sysdate),parm_print_date_high )
290: AND hzca.cust_account_id IN
291: ((SELECT cust_account_id
292: FROM hz_cust_accounts hzca
293: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
294: NVL(customer_class_code,'XXX'),parm_customer_class))
295: INTERSECT
296: (SELECT cust_account_id

Line 297: FROM hz_cust_accounts hzca

293: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
294: NVL(customer_class_code,'XXX'),parm_customer_class))
295: INTERSECT
296: (SELECT cust_account_id
297: FROM hz_cust_accounts hzca
298: WHERE cust_account_id like nvl(parm_customer,'%')))
299: and rct.customer_trx_id in
300: (SELECT CUSTOMER_TRX_ID
301: FROM RA_CUSTOMER_TRX