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 XLA_AE_HEADERS

Line 93: xla_ae_headers xah

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
95: adj.adjustment_id +0 < p_Report.NxtAdjustmentId
96: and adj.set_of_books_id = p_Report.SetOfBooksId
97: and nvl(adj.postable,'Y') = 'Y'

Line 122: from xla_ae_headers xah2

118: and xah.gl_transfer_status_code = 'Y'
119: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
120: /* Added for bug 6647672 start */
121: and NOT EXISTS ( select 'Y'
122: from xla_ae_headers xah2
123: where xah2.event_id = adj.event_id
124: and xah2.application_id = l_xah_ar_application_id
125: and xah2.ledger_id = adj.set_of_books_id
126: and xah2.ledger_id = p_Report.CashSetOfBooksId

Line 263: xla_ae_headers xah

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
265: ctlgd.cust_trx_line_gl_dist_id+0 < p_Report.NxtCustTrxLineGlDistId
266: and ctlgd.set_of_books_id = p_Report.SetOfBooksId
267: and ctlgd.account_set_flag = 'N'

Line 302: from xla_ae_headers xah2

298: and xah.gl_transfer_status_code = 'Y'
299: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
300: /* Added for bug 6647672 start */
301: and NOT EXISTS ( select 'Y'
302: from xla_ae_headers xah2
303: where xah2.event_id = ctlgd.event_id
304: and xah2.application_id = l_xah_ar_application_id
305: and xah2.ledger_id = ctlgd.set_of_books_id
306: and xah2.ledger_id = p_Report.CashSetOfBooksId

Line 439: xla_ae_headers xah

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
440: WHERE crh.cash_receipt_history_id+0 < p_Report.NxtCashReceiptHistoryId
441: and crh.cash_receipt_history_id = ard.source_id
442: and ard.source_table = 'CRH'
443: and cr.set_of_books_id = p_Report.SetOfBooksId

Line 469: from xla_ae_headers xah2

465: and xah.gl_transfer_status_code = 'Y'
466: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
467: /* Added for bug 6647672 start */
468: and NOT EXISTS ( select 'Y'
469: from xla_ae_headers xah2
470: where xah2.event_id = crh.event_id
471: and xah2.application_id = l_xah_ar_application_id
472: and xah2.ledger_id = cr.set_of_books_id
473: and xah2.ledger_id = p_Report.CashSetOfBooksId

Line 597: xla_ae_headers xah

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'
601: and ard.source_id = ra.receivable_application_id

Line 631: from xla_ae_headers xah2

627: and xah.gl_transfer_status_code = 'Y'
628: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
629: /* Added for bug 6647672 start */
630: and NOT EXISTS ( select 'Y'
631: from xla_ae_headers xah2
632: where xah2.event_id = ra.event_id
633: and xah2.application_id = l_xah_ar_application_id
634: and xah2.ledger_id = ra.set_of_books_id
635: and xah2.ledger_id = p_Report.CashSetOfBooksId

Line 702: xla_ae_headers xah

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'
706: and ard.source_id = ra.receivable_application_id

Line 739: from xla_ae_headers xah2

735: and xah.gl_transfer_status_code = 'Y'
736: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
737: /* Added for bug 6647672 start */
738: and NOT EXISTS ( select 'Y'
739: from xla_ae_headers xah2
740: where xah2.event_id = ra.event_id
741: and xah2.application_id = l_xah_ar_application_id
742: and xah2.ledger_id = ra.set_of_books_id
743: and xah2.ledger_id = p_Report.CashSetOfBooksId

Line 845: xla_ae_headers xah

841: ar_misc_cash_distributions mcd,
842: ar_distributions ard,
843: ar_cash_receipts cr,
844: ar_lookups l_cat,
845: xla_ae_headers xah
846: WHERE mcd.misc_cash_distribution_id+0 < p_Report.NxtMiscCashDistributionId
847: and mcd.set_of_books_id = p_Report.SetOfBooksId
848: and mcd.cash_receipt_id = cr.cash_receipt_id
849: and ard.source_table = 'MCD'

Line 871: from xla_ae_headers xah2

867: and xah.gl_transfer_status_code = 'Y'
868: and xah.gl_transfer_date between p_Report.PostedDateFrom and p_Report.PostedDateTo
869: /* Added for bug 6647672 start */
870: and NOT EXISTS ( select 'Y'
871: from xla_ae_headers xah2
872: where xah2.event_id = mcd.event_id
873: and xah2.application_id = l_xah_ar_application_id
874: and xah2.ledger_id = mcd.set_of_books_id
875: and xah2.ledger_id = p_Report.CashSetOfBooksId