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.ARP_XLA_EXTRACT_MAIN_PKG dependencies on GL_LEDGERS

Line 552: gl_ledgers sob

548: NVL(dist.ACCTD_AMOUNT_CR,0)-NVL(dist.ACCTD_AMOUNT_DR,0)
549: FROM xla_events_gt eve,
550: ar_receivable_applications_all app,
551: ar_distributions_all dist,
552: gl_ledgers sob
553: WHERE eve.application_id = 222
554: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
555: AND eve.event_id = app.event_id
556: AND app.status IN ('APP','ACTIVITY')

Line 4585: FROM gl_ledgers gl,

4581: PROCEDURE mfar_hook(p_ledger_id IN NUMBER)
4582: IS
4583: CURSOR c IS
4584: SELECT NULL
4585: FROM gl_ledgers gl,
4586: xla_acctg_method_rules mr,
4587: xla_product_rules_tl pr
4588: WHERE gl.ledger_id = p_ledger_id
4589: AND mr.application_id = 222

Line 6043: gl_ledgers lg

6039: FROM xla_events_gt gt,
6040: ar_cash_receipt_history_all crh,
6041: ar_cash_receipts_all cr,
6042: ar_distributions_all ard,
6043: gl_ledgers lg
6044: WHERE gt.application_id = 222
6045: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')
6046: AND gt.event_id = crh.event_id
6047: AND crh.postable_flag = 'Y'

Line 6111: gl_ledgers lg,

6107: ar_cash_receipts_all cr,
6108: ar_distributions_all ard,
6109: ar_cash_receipt_history_all paircrh,
6110: ar_distributions_all pairard,
6111: gl_ledgers lg,
6112: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6113: SELECT 'REV_DIST' AS status FROM DUAL) state
6114: WHERE gt.application_id = 222
6115: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')

Line 6176: gl_ledgers lg,

6172: ar_cash_receipts_all cr,
6173: ar_distributions_all ard,
6174: ar_cash_receipt_history_all paircrh,
6175: ar_distributions_all pairard,
6176: gl_ledgers lg,
6177: (SELECT 'ORG_DIST' AS status FROM DUAL UNION
6178: SELECT 'REV_DIST' AS status FROM DUAL) state
6179: WHERE gt.application_id = 222
6180: AND gt.event_type_code IN ('RECP_CREATE','RECP_UPDATE','MISC_RECP_CREATE','MISC_RECP_UPDATE','RECP_RATE_ADJUST')

Line 6484: gl_ledgers lg,

6480: ra_customer_trx_all trx,
6481: ra_cust_trx_line_gl_dist_all ctlgd,
6482: ra_customer_trx_lines_all ctl,
6483: ar_cash_receipts_all cr,
6484: gl_ledgers lg,
6485: ar_cash_receipt_history_all crhlatest,
6486: (SELECT source_id,
6487: MAX(line_id) max_line_id
6488: FROM ar_xla_lines_extract

Line 6601: gl_ledgers lg,

6597: ra_customer_trx_all trx,
6598: ra_cust_trx_line_gl_dist_all ctlgd,
6599: ra_customer_trx_lines_all ctl,
6600: ar_cash_receipts_all cr,
6601: gl_ledgers lg,
6602: (SELECT source_id,
6603: MAX(line_id) max_line_id
6604: FROM ar_xla_lines_extract
6605: WHERE source_table='RA'

Line 6714: gl_ledgers lg,

6710: ra_customer_trx_all trx,
6711: ra_cust_trx_line_gl_dist_all ctlgd,
6712: ra_customer_trx_lines_all ctl,
6713: ar_cash_receipts_all cr,
6714: gl_ledgers lg,
6715: ar_cash_receipt_history_all crhlatest,
6716: (SELECT source_id,
6717: MAX(line_id) max_line_id
6718: FROM ar_xla_lines_extract

Line 6834: gl_ledgers lg,

6830: ra_customer_trx_all trx,
6831: ra_cust_trx_line_gl_dist_all ctlgd,
6832: ra_customer_trx_lines_all ctl,
6833: ar_cash_receipts_all cr,
6834: gl_ledgers lg,
6835: ar_crh_gt crhgt,
6836: (SELECT source_id,
6837: MAX(line_id) max_line_id
6838: FROM ar_xla_lines_extract