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.IGIRCABJP dependencies on HZ_CUST_ACCOUNTS

Line 80: hz_cust_accounts.account_number ref26, -- Bug 3902175

76: to_char(adj.adjustment_id) ref22,
77: to_char(ard.line_id) ref23,
78: to_char(null) ref24,
79: ct.trx_number ref25,
80: hz_cust_accounts.account_number ref26, -- Bug 3902175
81: ct.bill_to_customer_id ref27,
82: 'ADJ' ref28,
83: 'ADJ' || ard.source_type ref29,
84: 'AR_ADJUSTMENTS' ref30

Line 90: hz_cust_accounts, -- Bug 3902175

86: ra_customer_trx_all ct,
87: ra_cust_trx_types_all ctt,
88: ar_distributions_all ard,
89: hz_parties, -- Bug 3902175
90: hz_cust_accounts, -- Bug 3902175
91: ar_adjustments_all adj,
92: ar_lookups l_cat,
93: xla_ae_headers xah
94: WHERE

Line 102: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175

98: and adj.adjustment_id = ard.source_id
99: and ard.source_table = 'ADJ'
100: and adj.customer_trx_id = ct.customer_trx_id
101: and ctt.cust_trx_type_id = ct.cust_trx_type_id
102: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
103: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
104: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
105: and l_cat.lookup_code = 'ADJ_' || ard.source_type
106: and ct.invoice_currency_code = decode( p_Report.FuncCurr,

Line 103: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

99: and ard.source_table = 'ADJ'
100: and adj.customer_trx_id = ct.customer_trx_id
101: and ctt.cust_trx_type_id = ct.cust_trx_type_id
102: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
103: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
104: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
105: and l_cat.lookup_code = 'ADJ_' || ard.source_type
106: and ct.invoice_currency_code = decode( p_Report.FuncCurr,
107: null,ct.invoice_currency_code,

Line 243: hz_cust_accounts.account_number ref26, -- Bug 3902175

239: to_char(ct.customer_trx_id) ref22,
240: to_char(ctlgd.cust_trx_line_gl_dist_id) ref23,
241: to_char(null) ref24,
242: ct.trx_number ref25,
243: hz_cust_accounts.account_number ref26, -- Bug 3902175
244: to_char(ct.bill_to_customer_id) ref27,
245: decode(ctt.type,
246: 'CM', 'CM',
247: 'DM', 'DM',

Line 260: hz_cust_accounts, -- Bug 3902175

256: FROM
257: ar_lookups l_cat,
258: ra_cust_trx_types ctt,
259: hz_parties, -- Bug 3902175
260: hz_cust_accounts, -- Bug 3902175
261: ra_customer_trx_all ct,
262: ra_cust_trx_line_gl_dist ctlgd,
263: xla_ae_headers xah
264: WHERE

Line 271: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

267: and ctlgd.account_set_flag = 'N'
268: and ctlgd.customer_trx_id = ct.customer_trx_id
269: and ct.complete_flag = 'Y'
270: and ct.cust_trx_type_id = ctt.cust_trx_type_id
271: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
272: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
273: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
274: and l_cat.lookup_code = decode(ctt.type,
275: 'CM', 'CM_',

Line 272: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175

268: and ctlgd.customer_trx_id = ct.customer_trx_id
269: and ct.complete_flag = 'Y'
270: and ct.cust_trx_type_id = ctt.cust_trx_type_id
271: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
272: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
273: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
274: and l_cat.lookup_code = decode(ctt.type,
275: 'CM', 'CM_',
276: 'DM', 'DM_',

Line 434: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id

430: 'TRADE_')||ard.source_type ref29,
431: 'AR_CASH_RECEIPT_HISTORY' ref30
432: FROM
433: ar_lookups l_cat,
434: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
435: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
436: ar_distributions ard,
437: ar_cash_receipts cr,
438: ar_cash_receipt_history_all crh,

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

431: 'AR_CASH_RECEIPT_HISTORY' ref30
432: FROM
433: ar_lookups l_cat,
434: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
435: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
436: ar_distributions ard,
437: ar_cash_receipts cr,
438: ar_cash_receipt_history_all crh,
439: xla_ae_headers xah

Line 595: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id

591: ar_lookups l_cat,
592: ar_posting_control pc,
593: ar_system_parameters sp,
594: gl_sets_of_books gl,
595: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
596: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
597: xla_ae_headers xah
598: WHERE
599: ra.receivable_application_id+0 < p_Report.NxtReceivableApplicationId

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

592: ar_posting_control pc,
593: ar_system_parameters sp,
594: gl_sets_of_books gl,
595: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
596: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
597: xla_ae_headers xah
598: WHERE
599: ra.receivable_application_id+0 < p_Report.NxtReceivableApplicationId
600: and ard.source_table = 'RA'

Line 685: hz_cust_accounts.account_number ref26, -- Bug 3902175

681: to_char(ra.receivable_application_id) ref22,
682: to_char(ard.line_id) ref23,
683: ctcm.trx_number ref24,
684: ctinv.trx_number ref25,
685: hz_cust_accounts.account_number ref26, -- Bug 3902175
686: to_char(ctcm.bill_to_customer_id) ref27,
687: 'CMAPP' ref28,
688: 'CMAPP_' || ard.source_type ref29,
689: 'AR_RECEIVABLE_APPLICATIONS' ref30

Line 701: hz_cust_accounts,

697: ar_posting_control pc,
698: ar_system_parameters sp,
699: gl_sets_of_books gl,
700: hz_parties,
701: hz_cust_accounts,
702: xla_ae_headers xah
703: WHERE
704: ra.receivable_application_id+0 < p_Report.NxtReceivableApplicationId
705: and ard.source_table = 'RA'

Line 715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

711: and ra.customer_trx_id = ctlgdcm.customer_trx_id
712: and ctlgdcm.account_class = 'REC'
713: and ctlgdcm.latest_rec_flag = 'Y'
714: and ra.applied_customer_trx_id = ctinv.customer_trx_id
715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
716: and hz_cust_accounts.cust_account_id = ctcm.bill_to_customer_id -- Bug 3902175
717: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
718: and l_cat.lookup_code = 'CMAPP_' || ard.source_type
719: and sp.set_of_books_id = p_Report.SetOfBooksId

Line 716: and hz_cust_accounts.cust_account_id = ctcm.bill_to_customer_id -- Bug 3902175

712: and ctlgdcm.account_class = 'REC'
713: and ctlgdcm.latest_rec_flag = 'Y'
714: and ra.applied_customer_trx_id = ctinv.customer_trx_id
715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
716: and hz_cust_accounts.cust_account_id = ctcm.bill_to_customer_id -- Bug 3902175
717: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
718: and l_cat.lookup_code = 'CMAPP_' || ard.source_type
719: and sp.set_of_books_id = p_Report.SetOfBooksId
720: and sp.set_of_books_id = gl.set_of_books_id