eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_IPAC dependencies on HZ_CUST_ACCOUNTS

Line 98: hz_cust_accounts hzca,

94: DECODE(hzp.PARTY_TYPE,'ORGANIZATION', hzp.DUNS_NUMBER_C,NULL) duns_number_c,
95: rsu.Cust_Acct_site_ID bill_to_address_id,
96: rct.invoice_currency_code
97: FROM hz_parties hzp,
98: hz_cust_accounts hzca,
99: ra_customer_trx rct,
100: ra_cust_trx_types rtt,
101: HZ_CUST_SITE_USES rsu ,
102: ar_remit_to_addresses_v arem,

Line 128: hz_cust_accounts hca

124: AND hzca.cust_account_id IN
125: (
126: (SELECT hzca.cust_account_id
127: FROM hz_parties hp,
128: hz_cust_accounts hca
129: WHERE hp.party_id = hca.party_id
130: AND NVL(category_code,'XXX') LIKE DECODE(parm_customer_category,NULL, NVL(category_code,'XXX'), parm_customer_category)
131: )
132: INTERSECT

Line 134: FROM hz_cust_accounts

130: AND NVL(category_code,'XXX') LIKE DECODE(parm_customer_category,NULL, NVL(category_code,'XXX'), parm_customer_category)
131: )
132: INTERSECT
133: (SELECT cust_account_id
134: FROM hz_cust_accounts
135: WHERE cust_account_id LIKE DECODE(parm_customer_id,NULL, '%',parm_customer_id)
136: )
137: )
138: AND rct.trx_date BETWEEN DECODE(parm_trx_date_low,NULL, TO_DATE('1990/1/1', 'yyyy/mm/dd'), parm_trx_date_low) AND DECODE(parm_trx_date_high,NULL,TRUNC(SYSDATE), parm_trx_date_high)