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 99: hz_cust_accounts hzca,

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

Line 129: hz_cust_accounts hca

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

Line 135: FROM hz_cust_accounts

131: AND NVL(category_code,'XXX') LIKE DECODE(parm_customer_category,NULL, NVL(category_code,'XXX'), parm_customer_category)
132: )
133: INTERSECT
134: (SELECT cust_account_id
135: FROM hz_cust_accounts
136: WHERE cust_account_id LIKE DECODE(parm_customer_id,NULL, '%',parm_customer_id)
137: )
138: )
139: 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)