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 3226: ar_distributions_all ard,

3222: ar_system_parameters_all asp,
3223: xla_distribution_links xdl,
3224: ar_cash_receipt_history_all crh,
3225: xla_upgrade_dates gps,
3226: ar_distributions_all ard,
3227: gl_je_lines gjl
3228: where xte.source_id_int_1 = cr.cash_receipt_id
3229: AND xah.accounting_date BETWEEN GPS.START_DATE AND GPS.END_DATE
3230: and xte.upg_batch_id is not null

Line 3242: and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3238: and xah.application_id = xal.application_id
3239: and xal.ae_header_id = xdl.ae_header_id
3240: and xal.ae_line_num = xdl.ae_line_num
3241: and xal.application_id = xdl.application_id
3242: and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3243: and asp.set_of_books_id = cr.set_of_books_id
3244: and asp.accounting_method = 'CASH'
3245: and cr.cash_receipt_id = crh.cash_receipt_id
3246: and ard.source_id = crh.cash_receipt_history_id

Line 3277: ar_distributions_all ard,

3273: ar_system_parameters_all asp,
3274: xla_distribution_links xdl,
3275: ar_receivable_applications_all unapp,
3276: xla_upgrade_dates gps,
3277: ar_distributions_all ard,
3278: gl_je_lines gjl
3279: where xte.source_id_int_1 = cr.cash_receipt_id
3280: AND xah.accounting_date BETWEEN GPS.START_DATE AND GPS.END_DATE
3281: and xte.upg_batch_id is not null

Line 3293: and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

3289: and xah.application_id = xal.application_id
3290: and xal.ae_header_id = xdl.ae_header_id
3291: and xal.ae_line_num = xdl.ae_line_num
3292: and xal.application_id = xdl.application_id
3293: and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
3294: and asp.set_of_books_id = cr.set_of_books_id
3295: and asp.accounting_method = 'CASH'
3296: and cr.cash_receipt_id = unapp.cash_receipt_id
3297: and ard.source_id = unapp.receivable_application_id

Line 3415: THEN 'AR_DISTRIBUTIONS_ALL'

3411: WHEN GIMP.REFERENCE_10 IN
3412: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS',
3413: 'AR_MISC_CASH_DISTRIBUTIONS',
3414: 'AR_RECEIVABLE_APPLICATIONS', 'AR_CASH_RECEIPT_HISTORY')
3415: THEN 'AR_DISTRIBUTIONS_ALL'
3416: ELSE NULL
3417: END )
3418: AND LN.APPLICATION_ID = 222
3419: AND LNK.AE_HEADER_ID = LN.AE_HEADER_ID

Line 4593: 'AR_DISTRIBUTIONS_ALL' source_table,

4589: ( select
4590: hdr.ae_header_id ae_header_id,
4591: decode(ard.source_type, 'BANK_CHARGES', 'BANK_CHG',
4592: ard.source_type) account_class,
4593: 'AR_DISTRIBUTIONS_ALL' source_table,
4594: ard.code_combination_id code_combination_id,
4595: ard.amount_dr amount_dr,
4596: ard.amount_cr amount_cr,
4597: ard.acctd_amount_dr acctd_amount_dr,

Line 4624: ar_distributions_all ard

4620: ar_cash_receipt_history_all crh1,
4621: xla_transaction_entities_upg ent,
4622: xla_events ev,
4623: xla_ae_headers hdr,
4624: ar_distributions_all ard
4625: where nvl(cr.ax_accounted_flag,'N') = 'N'
4626: and cr.cash_receipt_id = crh.cash_receipt_id
4627: and cr.cash_receipt_id = p_cash_receipt_id
4628: and not exists (

Line 4634: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'

4630: where xdl.application_id = 222
4631: and xdl.source_distribution_id_num_1 = ard.line_id
4632: and xdl.ae_header_id = hdr.ae_header_id
4633: and xdl.event_id = hdr.event_id
4634: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'
4635: )
4636: -- and trunc(crh.gl_date) between gps.start_date and gps.end_date
4637: -- and gps.ledger_id = cr.set_of_books_id
4638: and cr.cash_receipt_id = crh1.cash_receipt_id (+)

Line 4697: 'AR_DISTRIBUTIONS_ALL' source_table,

4693: -8,'REFUND',
4694: -9,'CHARGEBACK',
4695: ard.source_type),
4696: ard.source_type) account_class,
4697: 'AR_DISTRIBUTIONS_ALL' source_table,
4698: ard.code_combination_id code_combination_id,
4699: ard.amount_dr amount_dr,
4700: ard.amount_cr amount_cr,
4701: ard.acctd_amount_dr acctd_amount_dr,

Line 4730: ar_distributions_all ard

4726: ar_cash_receipt_history_all crh,
4727: ar_cash_receipt_history_all crh1,
4728: xla_events ev,
4729: xla_ae_headers hdr,
4730: ar_distributions_all ard
4731: where nvl(cr.ax_accounted_flag,'N') = 'N'
4732: and nvl(sys.org_id,-9999) = nvl(cr.org_id, -9999)
4733: and ( sys.accounting_method = 'ACCRUAL' or ( sys.accounting_method = 'CASH' and app.status in ('UNAPP', 'UNID', 'ACC') ) )
4734: and cr.cash_receipt_id = app.cash_receipt_id

Line 4742: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'

4738: where xdl.application_id = 222
4739: and xdl.source_distribution_id_num_1 = ard.line_id
4740: and xdl.ae_header_id = hdr.ae_header_id
4741: and xdl.event_id = hdr.event_id
4742: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'
4743: )
4744: and app.application_type = 'CASH'
4745: -- and trunc(app.gl_date) between gps.start_date and gps.end_date
4746: -- and gps.ledger_id = cr.set_of_books_id

Line 4787: 'AR_DISTRIBUTIONS_ALL' source_table,

4783: select
4784: hdr.ae_header_id ae_header_id,
4785: DECODE(ard.source_type, 'MISCCASH', 'MISC_CASH',
4786: ard.source_type) account_class,
4787: 'AR_DISTRIBUTIONS_ALL' source_table,
4788: ard.code_combination_id code_combination_id,
4789: ard.amount_dr amount_dr,
4790: ard.amount_cr amount_cr,
4791: ard.acctd_amount_dr acctd_amount_dr,

Line 4815: ar_distributions_all ard

4811: ar_cash_receipt_history_all crh,
4812: xla_transaction_entities_upg ent,
4813: xla_events ev,
4814: xla_ae_headers hdr,
4815: ar_distributions_all ard
4816: where nvl(cr.ax_accounted_flag,'N') = 'N'
4817: and cr.cash_receipt_id = mcd.cash_receipt_id
4818: and cr.cash_receipt_id = p_cash_receipt_id
4819: -- and trunc(mcd.gl_date) between gps.start_date and gps.end_date

Line 4828: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'

4824: where xdl.application_id = 222
4825: and xdl.source_distribution_id_num_1 = ard.line_id
4826: and xdl.ae_header_id = hdr.ae_header_id
4827: and xdl.event_id = hdr.event_id
4828: and xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'
4829: )
4830: and crh.first_posted_record_flag = 'Y'
4831: and ent.application_id = 222
4832: and ent.ledger_id = cr.set_of_books_id