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.IGIRCBJP dependencies on HZ_PARTIES

Line 1186: hz_parties, -- Bug 3902175

1182: l_cat.meaning CatMeaning
1183: FROM ar_receivable_applications ra,
1184: igi_ar_rec_applications igira,
1185: ar_cash_receipts cr,
1186: hz_parties, -- Bug 3902175
1187: hz_cust_accounts, -- Bug 3902175
1188: ar_lookups l_cat,
1189: xla_ae_headers xah
1190: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom

Line 1203: AND hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

1199: AND ra.status <> 'UNID')
1200: OR
1201: ra.status = 'UNID'
1202: )
1203: AND hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
1204: AND l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
1205: AND l_cat.lookup_code = decode(ra.amount_applied_from,
1206: null,'TRADE_APP','CCURR_APP')
1207: AND cr.currency_code = DECODE( p_Report.Currency,

Line 1481: hz_parties, -- Bug 3902175

1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1480: ar_lookups l_cat,
1481: hz_parties, -- Bug 3902175
1482: hz_cust_accounts, -- Bug 3902175
1483: xla_ae_headers xah
1484: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1485: AND p_Report.GLDateTo

Line 1496: AND hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

1492: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1493: AND ctcm.previous_customer_trx_id IS NULL
1494: AND ra.applied_customer_trx_id = ct.customer_trx_id
1495: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1496: AND hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
1497: AND l.lookup_type = 'AR_CARTESIAN_JOIN'
1498: AND (
1499: ( l.lookup_code ='1' )
1500: OR

Line 1709: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175

1705: FROM ar_cash_receipt_history crh,
1706: igi_ar_cash_receipt_hist igicrh,
1707: ar_cash_receipts cr,
1708: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
1709: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
1710: ar_lookups l_cat,
1711: ar_distributions d,
1712: xla_ae_headers xah
1713: WHERE crh.gl_date BETWEEN p_Report.GlDateFrom