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_UPGRADE dependencies on AR_DISTRIBUTIONS_ALL

Line 756: 'AR_DISTRIBUTIONS_ALL' source_table,

752: select /*+ ordered rowid(ct) use_nl(app,ent,ev,hdr,ard) use_hash(gps) swap_join_inputs(gps) INDEX(ent xla_transaction_entities_N1) INDEX(ev XLA_EVENTS_U2) INDEX(hdr XLA_AE_HEADERS_N2) */
753: hdr.ae_header_id ae_header_id,
754: DECODE(ard.source_type, 'REC','RECEIVABLE',
755: ard.source_type) account_class,
756: 'AR_DISTRIBUTIONS_ALL' source_table,
757: ard.code_combination_id code_combination_id,
758: ard.amount_dr amount_dr,
759: ard.amount_cr amount_cr,
760: ard.acctd_amount_dr acctd_amount_dr,

Line 786: ar_distributions_all ard

782: xla_upgrade_dates gps,
783: xla_transaction_entities_upg ent,
784: xla_events ev,
785: xla_ae_headers hdr,
786: ar_distributions_all ard
787: where ct.rowid >= l_start_rowid
788: and ct.rowid <= l_end_rowid
789: and NVL(ct.ax_accounted_flag,'N') = 'N'
790: and ct.customer_trx_id = app.customer_trx_id

Line 1412: 'AR_DISTRIBUTIONS_ALL' source_table,

1408: 'REMITTANCE','REM_BR',
1409: 'REC', 'BILL_REC',
1410: 'UNPAIDREC', 'UNPAID_BR',
1411: ard.source_type) account_class,
1412: 'AR_DISTRIBUTIONS_ALL' source_table,
1413: ard.code_combination_id code_combination_id,
1414: ard.amount_dr amount_dr,
1415: ard.amount_cr amount_cr,
1416: ard.acctd_amount_dr acctd_amount_dr,

Line 1439: ar_distributions_all ard

1435: xla_upgrade_dates gps,
1436: xla_transaction_entities_upg ent,
1437: xla_events ev,
1438: xla_ae_headers hdr,
1439: ar_distributions_all ard
1440: where ct.rowid >= l_start_rowid
1441: and ct.rowid <= l_end_rowid
1442: and NVL(ct.ax_accounted_flag,'N') = 'N'
1443: and ct.customer_trx_id = trh.customer_trx_id

Line 2276: 'AR_DISTRIBUTIONS_ALL' source_table,

2272: ( select /*+ ordered rowid(cr) use_nl(crh,crh1,ent,ev,hdr,ard) use_hash(gps) swap_join_inputs(gps) INDEX(ent xla_transaction_entities_N1) INDEX(ev XLA_EVENTS_U2) INDEX(hdr XLA_AE_HEADERS_N2) INDEX_SS(crh1 ar_cash_receipt_history_n1) */
2273: hdr.ae_header_id ae_header_id,
2274: decode(ard.source_type, 'BANK_CHARGES', 'BANK_CHG',
2275: ard.source_type) account_class,
2276: 'AR_DISTRIBUTIONS_ALL' source_table,
2277: ard.code_combination_id code_combination_id,
2278: ard.amount_dr amount_dr,
2279: ard.amount_cr amount_cr,
2280: ard.acctd_amount_dr acctd_amount_dr,

Line 2306: ar_distributions_all ard

2302: ar_cash_receipt_history_all crh1,
2303: xla_transaction_entities_upg ent,
2304: xla_events ev,
2305: xla_ae_headers hdr,
2306: ar_distributions_all ard
2307: where cr.rowid >= l_start_rowid
2308: and cr.rowid <= l_end_rowid
2309: and nvl(cr.ax_accounted_flag,'N') = 'N'
2310: and cr.cash_receipt_id = crh.cash_receipt_id

Line 2371: 'AR_DISTRIBUTIONS_ALL' source_table,

2367: -8,'REFUND',
2368: -9,'CHARGEBACK',
2369: ard.source_type),
2370: ard.source_type) account_class,
2371: 'AR_DISTRIBUTIONS_ALL' source_table,
2372: ard.code_combination_id code_combination_id,
2373: ard.amount_dr amount_dr,
2374: ard.amount_cr amount_cr,
2375: ard.acctd_amount_dr acctd_amount_dr,

Line 2403: ar_distributions_all ard

2399: ar_cash_receipt_history_all crh,
2400: ar_cash_receipt_history_all crh1,
2401: xla_events ev,
2402: xla_ae_headers hdr,
2403: ar_distributions_all ard
2404: where cr.rowid >= l_start_rowid
2405: and cr.rowid <= l_end_rowid
2406: and nvl(cr.ax_accounted_flag,'N') = 'N'
2407: and nvl(sys.org_id,-9999) = nvl(cr.org_id, -9999)

Line 2452: 'AR_DISTRIBUTIONS_ALL' source_table,

2448: select /*+ ordered rowid(cr) use_nl(mcd,crh,ent,ev,hdr,ard) use_hash(gps) swap_join_inputs(gps) INDEX(ent xla_transaction_entities_N1) INDEX(ev XLA_EVENTS_U2) INDEX(hdr XLA_AE_HEADERS_N2) INDEX_SS(crh ar_cash_receipt_history_n1) */
2449: hdr.ae_header_id ae_header_id,
2450: DECODE(ard.source_type, 'MISCCASH', 'MISC_CASH',
2451: ard.source_type) account_class,
2452: 'AR_DISTRIBUTIONS_ALL' source_table,
2453: ard.code_combination_id code_combination_id,
2454: ard.amount_dr amount_dr,
2455: ard.amount_cr amount_cr,
2456: ard.acctd_amount_dr acctd_amount_dr,

Line 2479: ar_distributions_all ard

2475: ar_cash_receipt_history_all crh,
2476: xla_transaction_entities_upg ent,
2477: xla_events ev,
2478: xla_ae_headers hdr,
2479: ar_distributions_all ard
2480: where cr.rowid >= l_start_rowid
2481: and cr.rowid <= l_end_rowid
2482: and nvl(cr.ax_accounted_flag,'N') = 'N'
2483: and cr.cash_receipt_id = mcd.cash_receipt_id

Line 3034: 'AR_DISTRIBUTIONS_ALL' source_table,

3030: ( select /*+ ordered rowid(adj) use_nl(ent,ev,hdr,ard) use_hash(gps) swap_join_inputs(gps) INDEX(ent xla_transaction_entities_N1) INDEX(ev XLA_EVENTS_U2) INDEX(hdr XLA_AE_HEADERS_N2) */
3031: hdr.ae_header_id ae_header_id,
3032: DECODE(ard.source_type,'REC','RECEIVABLE',
3033: ard.source_type) account_class,
3034: 'AR_DISTRIBUTIONS_ALL' source_table,
3035: ard.code_combination_id code_combination_id,
3036: ard.amount_dr amount_dr,
3037: ard.amount_cr amount_cr,
3038: ard.acctd_amount_dr acctd_amount_dr,

Line 3058: ar_distributions_all ard

3054: xla_upgrade_dates gps,
3055: xla_transaction_entities_upg ent,
3056: xla_events ev,
3057: xla_ae_headers hdr,
3058: ar_distributions_all ard
3059: where adj.rowid >= l_start_rowid
3060: and adj.rowid <= l_end_rowid
3061: and nvl(adj.ax_accounted_flag,'N') = 'N'
3062: and trunc(adj.gl_date) between gps.start_date and gps.end_date

Line 3229: THEN 'AR_DISTRIBUTIONS_ALL'

3225: WHEN GIMP.REFERENCE_10 IN
3226: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS',
3227: 'AR_MISC_CASH_DISTRIBUTIONS',
3228: 'AR_RECEIVABLE_APPLICATIONS', 'AR_CASH_RECEIPT_HISTORY')
3229: THEN 'AR_DISTRIBUTIONS_ALL'
3230: ELSE NULL
3231: END )
3232: AND LN.APPLICATION_ID = 222
3233: AND LNK.AE_HEADER_ID = LN.AE_HEADER_ID