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_RECON_REP dependencies on AR_LOOKUPS

Line 533: from ar_lookups

529: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
530: ELSE
531: select meaning
532: into l_organization
533: from ar_lookups
534: where lookup_code ='ALL' and lookup_type ='ALL';
535: END IF;
536:
537: /* Build the WHERE clauses */

Line 641: from ar_lookups

637:
638: IF p_posting_status IS NOT NULL THEN
639: select meaning
640: into l_status_meaning
641: from ar_lookups
642: where lookup_type = 'POSTED_STATUS'
643: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
644:
645: l_posting_status_where := 'and nvl(adj.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =

Line 688: ar_lookups look,

684: ar_receivables_trx rec,
685: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
686: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
687: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
688: ar_lookups look,
689: ar_lookups l_cat
690: where trx.complete_flag = ''Y''
691: and cust.cust_account_id = trx.bill_to_customer_id
692: and cust.party_id = party.party_id

Line 689: ar_lookups l_cat

685: '||arp_recon_rep.var_tname.l_ra_customer_trx_all||' trx,
686: '||arp_recon_rep.var_tname.l_ar_adjustments_all||' adj,
687: '||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
688: ar_lookups look,
689: ar_lookups l_cat
690: where trx.complete_flag = ''Y''
691: and cust.cust_account_id = trx.bill_to_customer_id
692: and cust.party_id = party.party_id
693: and trx.set_of_books_id = arp_recon_rep.get_set_of_books_id()

Line 1057: from ar_lookups

1053: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1054: ELSE
1055: select meaning
1056: into l_organization
1057: from ar_lookups
1058: where lookup_code ='ALL' and lookup_type ='ALL';
1059: END IF;
1060:
1061: /* Build the WHERE clauses */

Line 1190: from ar_lookups

1186:
1187: IF p_posting_status IS NOT NULL THEN
1188: select meaning
1189: into l_status_meaning
1190: from ar_lookups
1191: where lookup_type = 'POSTED_STATUS'
1192: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
1193:
1194: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =

Line 1260: ar_lookups l_cat

1256: ar_distributions_all ard,
1257: xla_distribution_links lk,
1258: xla_ae_lines ae,
1259: xla_ae_headers hd,
1260: ar_lookups l_cat
1261: where ae.accounting_class_code IN (''CASH'', ''REMITTANCE'', ''CONFIRMATION''
1262: , ''FV_CASH_CR'', ''FV_CASH_DR'', ''RECEIVABLE''
1263: , ''FREIGHT'', ''TAX'', ''DEFERRED_TAX''
1264: , ''REVENUE'', ''UNEARNED_REVENUE'', ''UNBILL''

Line 1353: ar_lookups l_cat

1349: ar_batch_sources bs,
1350: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1351: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1352: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1353: ar_lookups l_cat
1354: where
1355: ra.status IN (''ACC'', ''OTHER ACC'')
1356: AND ps.cash_receipt_id = ra.cash_receipt_id
1357: AND ps.class = ''PMT''

Line 1425: ar_lookups l_cat

1421: ar_batch_sources bs,
1422: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
1423: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1424: ar_distributions_all ard,
1425: ar_lookups l_cat
1426: where ra.status IN (''UNAPP'', ''UNID'')
1427: AND EXISTS
1428: (SELECT NULL
1429: FROM xla_distribution_links lk

Line 1509: ar_lookups l_cat

1505: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1506: xla_distribution_links lk,
1507: xla_ae_lines ae,
1508: xla_ae_headers hd,
1509: ar_lookups l_cat
1510: where ae.accounting_class_code IN (''CASH'', ''REMITTANCE'', ''CONFIRMATION''
1511: , ''FV_CASH_CR'', ''FV_CASH_DR'', ''RECEIVABLE''
1512: , ''FREIGHT'', ''TAX'', ''DEFERRED_TAX''
1513: , ''REVENUE'', ''UNEARNED_REVENUE'', ''UNBILL''

Line 1597: ar_lookups l_cat

1593: '||arp_recon_rep.var_tname.l_ar_batches_all||' bat,
1594: ar_batch_sources bs,
1595: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1596: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1597: ar_lookups l_cat
1598: where ps.class = ''PMT'' --ps.cash_receipt_id = ard.cash_receipt_id
1599: '||l_gl_date_closed_where||'
1600: AND cr.cash_receipt_id = ps.cash_receipt_id
1601: AND cr.receipt_method_id = arm.receipt_method_id

Line 1673: ar_lookups l_cat

1669: ar_receivable_applications ra,
1670: xla_distribution_links lk,
1671: xla_ae_lines ae,
1672: xla_ae_headers hd,
1673: ar_lookups l_cat
1674: where ae.accounting_class_code IN (''CASH'', ''REMITTANCE'', ''CONFIRMATION''
1675: , ''FV_CASH_CR'', ''FV_CASH_DR'', ''RECEIVABLE''
1676: , ''FREIGHT'', ''TAX'', ''DEFERRED_TAX''
1677: , ''REVENUE'', ''UNEARNED_REVENUE'', ''UNBILL''

Line 1767: ar_lookups l_cat

1763: ar_batch_sources bs,
1764: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1765: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1766: ar_receivable_applications ra,
1767: ar_lookups l_cat
1768: where ra.status IN (''APP'', ''ACC'', ''ACTIVITY'', ''OTHER ACC'')
1769: --AND ps.cash_receipt_id = ard.cash_receipt_id
1770: AND ps.class = ''PMT''
1771: '||l_gl_date_closed_where||'

Line 1837: ar_lookups l_cat

1833: ar_batch_sources bs,
1834: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
1835: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
1836: ar_receivable_applications ra,
1837: ar_lookups l_cat
1838: where ra.status IN (''UNAPP'', ''UNID'')
1839: --AND ps.cash_receipt_id = ard.cash_receipt_id
1840: AND ps.class = ''PMT''
1841: '||l_gl_date_closed_where||'

Line 2274: from ar_lookups

2270: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2271: ELSE
2272: select meaning
2273: into l_organization
2274: from ar_lookups
2275: where lookup_code ='ALL' and lookup_type ='ALL';
2276: END IF;
2277:
2278:

Line 2442: from ar_lookups

2438: IF p_posting_status IS NOT NULL THEN
2439:
2440: select meaning
2441: into l_status_meaning
2442: from ar_lookups
2443: where lookup_type = 'POSTED_STATUS'
2444: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
2445:
2446: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =

Line 2503: ar_lookups l_cat

2499: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2500: xla_distribution_links lk,
2501: xla_ae_lines ae,
2502: xla_ae_headers hd,
2503: ar_lookups l_cat
2504: where ae.accounting_class_code IN (''CASH'', ''REMITTANCE'', ''CONFIRMATION''
2505: , ''FV_CASH_CR'', ''FV_CASH_DR'', ''RECEIVABLE''
2506: , ''FREIGHT'', ''TAX'', ''DEFERRED_TAX''
2507: , ''REVENUE'', ''UNEARNED_REVENUE'', ''UNBILL''

Line 2604: ar_lookups l_cat

2600: ar_batch_sources bs,
2601: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2602: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
2603: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2604: ar_lookups l_cat
2605: where ra.status IN (''APP'',''ACC'', ''ACTIVITY'', ''OTHER ACC'')
2606: AND cr.cash_receipt_id = ra.cash_receipt_id
2607: AND cr.receipt_method_id = arm.receipt_method_id
2608: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 2678: ar_lookups l_cat

2674: ar_batch_sources bs,
2675: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2676: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
2677: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2678: ar_lookups l_cat
2679: where ra.status IN (''UNAPP'', ''UNID'')
2680: AND cr.cash_receipt_id = ra.cash_receipt_id
2681: AND cr.receipt_method_id = arm.receipt_method_id
2682: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 2766: ar_lookups l_cat

2762: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2763: xla_distribution_links lk,
2764: xla_ae_lines ae,
2765: xla_ae_headers hd,
2766: ar_lookups l_cat
2767: where ae.accounting_class_code IN (''CASH'', ''REMITTANCE'', ''CONFIRMATION''
2768: , ''FV_CASH_CR'', ''FV_CASH_DR'', ''RECEIVABLE''
2769: , ''FREIGHT'', ''TAX'', ''DEFERRED_TAX''
2770: , ''REVENUE'', ''UNEARNED_REVENUE'', ''UNBILL''

Line 2867: ar_lookups l_cat

2863: ar_batch_sources bs,
2864: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2865: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
2866: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2867: ar_lookups l_cat
2868: where ra.status IN (''APP'', ''ACC'', ''ACTIVITY'', ''OTHER ACC'')
2869: AND cr.cash_receipt_id = ra.cash_receipt_id
2870: AND cr.receipt_method_id = arm.receipt_method_id
2871: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 2941: ar_lookups l_cat

2937: ar_batch_sources bs,
2938: '||arp_recon_rep.var_tname.l_ar_receivable_apps_all||' ra,
2939: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps,
2940: ar_distributions_all ard, ---'||arp_recon_rep.var_tname.l_ar_distributions_all||' ard,
2941: ar_lookups l_cat
2942: where ra.status IN (''UNAPP'', ''UNID'')
2943: AND cr.cash_receipt_id = ra.cash_receipt_id
2944: AND cr.receipt_method_id = arm.receipt_method_id
2945: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 3345: from ar_lookups

3341: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3342: ELSE
3343: select meaning
3344: into l_organization
3345: from ar_lookups
3346: where lookup_code ='ALL' and lookup_type ='ALL';
3347: END IF;
3348:
3349: /* Build the WHERE clauses */

Line 3453: from ar_lookups

3449:
3450: IF p_posting_status IS NOT NULL THEN
3451: select meaning
3452: into l_status_meaning
3453: from ar_lookups
3454: where lookup_type = 'POSTED_STATUS'
3455: and lookup_code = arp_recon_rep.var_tname.g_posting_status;
3456:
3457: l_posting_status_where := 'and nvl(ra.gl_posted_date,TO_DATE(''01/01/0001'',''MM/DD/YYYY'')) =

Line 3498: ar_lookups l_cat

3494: '||arp_recon_rep.var_tname.l_ar_payment_schedules_all||' ps1 ,
3495: gl_code_combinations gc,
3496: hz_cust_accounts cust,
3497: hz_parties party,
3498: ar_lookups l_cat
3499: where nvl(ra.confirmed_flag,''Y'') = ''Y''
3500: and ra.application_type = ''CM''
3501: and ra.status = ''APP''
3502: and ard.source_table = ''RA''

Line 3781: from ar_lookups

3777:
3778: /* Get the org name */
3779: select meaning
3780: into l_organization
3781: from ar_lookups
3782: where lookup_code ='ALL' and lookup_type ='ALL';
3783:
3784: /* Build the other WHERE clauses */
3785: IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN