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.AR_AGING_BUCKETS_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 1407: from ar_payment_schedules ps '||l_from_clause||'

1403:
1404: l_inv_sub_query := '
1405: select ps.payment_schedule_id,
1406: ''INV'' source_type
1407: from ar_payment_schedules ps '||l_from_clause||'
1408: WHERE ps.gl_date_closed > :as_of_date
1409: AND ps.gl_date <= :as_of_date
1410: AND DECODE(UPPER(:pg_in_currency),NULL, ps.invoice_currency_code,
1411: UPPER(:pg_in_currency)) = ps.invoice_currency_code

Line 1427: select /+ leading(crh) index(ps AR_PAYMENT_SCHEDULES_U2)/

1423: <= :pg_in_invoice_type_high ';
1424: END IF;
1425:
1426: l_crh_sub_query := '
1427: select /*+ leading(crh) index(ps AR_PAYMENT_SCHEDULES_U2)*/
1428: distinct ps.payment_schedule_id,
1429: ''CRH'' source_type
1430: from ar_cash_receipt_history crh,
1431: ar_payment_schedules ps '||l_from_clause||'

Line 1431: ar_payment_schedules ps '||l_from_clause||'

1427: select /*+ leading(crh) index(ps AR_PAYMENT_SCHEDULES_U2)*/
1428: distinct ps.payment_schedule_id,
1429: ''CRH'' source_type
1430: from ar_cash_receipt_history crh,
1431: ar_payment_schedules ps '||l_from_clause||'
1432: where crh.gl_date <= :as_of_date
1433: and ( crh.current_record_flag = ''Y'' OR
1434: crh.reversal_gl_date > :as_of_date )
1435: and crh.status NOT IN

Line 1451: select /+ leading(ps) index(ps AR_PAYMENT_SCHEDULES_N9) index(app AR_RECEIVABLE_APPLICATIONS_N1)/

1447: AND applied_payment_schedule_id = -2
1448: )'||pg_org_where_crh||l_where_clause;
1449:
1450: l_ra_sub_query := '
1451: select /*+ leading(ps) index(ps AR_PAYMENT_SCHEDULES_N9) index(app AR_RECEIVABLE_APPLICATIONS_N1)*/
1452: distinct ps.payment_schedule_id,
1453: ''RA'' source_type
1454: from ar_receivable_applications app,
1455: ar_payment_schedules ps '||l_from_clause||'

Line 1455: ar_payment_schedules ps '||l_from_clause||'

1451: select /*+ leading(ps) index(ps AR_PAYMENT_SCHEDULES_N9) index(app AR_RECEIVABLE_APPLICATIONS_N1)*/
1452: distinct ps.payment_schedule_id,
1453: ''RA'' source_type
1454: from ar_receivable_applications app,
1455: ar_payment_schedules ps '||l_from_clause||'
1456: where app.gl_date <= :as_of_date
1457: AND app.status IN ( ''ACC'' ,
1458: ''UNAPP'',
1459: ''UNID'' ,

Line 1627: -- ar_payment_schedules ps,

1623: -- ps.invoice_currency_code,
1624: -- nvl(ps.exchange_rate, 1) exchange_rate,
1625: -- ps.cons_inv_id
1626: -- FROM ar_aging_payment_schedules aging,
1627: -- ar_payment_schedules ps,
1628: -- ra_customer_trx ct,
1629: -- ar_adjustments adj
1630: -- WHERE aging.parent_request_id = :parent_request_id
1631: -- AND aging.worker_id = :worker_id

Line 2138: ar_payment_schedules ps,

2134: ps.invoice_currency_code,
2135: nvl(ps.exchange_rate,1) exchange_rate,
2136: 0 cons_inv_id
2137: FROM ar_aging_payment_schedules aging,
2138: ar_payment_schedules ps,
2139: ar_adjustments adj
2140: WHERE aging.parent_request_id = :parent_request_id
2141: AND aging.worker_id = :worker_id
2142: AND aging.source_type = ''INV''

Line 2209: ar_payment_schedules ps,

2205: ps.invoice_currency_code,
2206: nvl(ps.exchange_rate, 1) exchange_rate,
2207: 0 cons_inv_id
2208: FROM ar_aging_payment_schedules aging,
2209: ar_payment_schedules ps,
2210: ar_receivable_applications app
2211: WHERE aging.parent_request_id = :parent_request_id
2212: AND aging.worker_id = :worker_id
2213: AND aging.source_type = ''INV''

Line 2267: ar_payment_schedules ps,

2263: ps.invoice_currency_code,
2264: nvl(ps.exchange_rate, 1) exchange_rate,
2265: ps.cons_inv_id
2266: FROM ar_aging_payment_schedules aging,
2267: ar_payment_schedules ps,
2268: ra_customer_trx ct
2269: WHERE aging.parent_request_id = :parent_request_id
2270: AND aging.worker_id = :worker_id
2271: AND aging.source_type = ''INV''

Line 2442: ar_payment_schedules ps,

2438: '''|| pg_payment_meaning ||''' invoice_type '|| l_rep_specific_cols ||'
2439: from hz_cust_accounts cust_acct,
2440: hz_parties party,
2441: ar_aging_payment_schedules aging,
2442: ar_payment_schedules ps,
2443: hz_cust_site_uses site,
2444: hz_cust_acct_sites acct_site,
2445: hz_party_sites party_site,
2446: hz_locations loc,

Line 2553: ar_payment_schedules ps,

2549: '''|| pg_risk_meaning ||''' invoice_type '|| l_rep_specific_cols ||'
2550: from hz_cust_accounts cust_acct,
2551: hz_parties party,
2552: ar_aging_payment_schedules aging,
2553: ar_payment_schedules ps,
2554: hz_cust_site_uses site,
2555: hz_cust_acct_sites acct_site,
2556: hz_party_sites party_site,
2557: hz_locations loc,

Line 2663: ar_payment_schedules ps,

2659: '|| l_rep_specific_cols ||'
2660: from hz_cust_accounts cust_acct,
2661: hz_parties party,
2662: ar_aging_payment_schedules aging,
2663: ar_payment_schedules ps,
2664: hz_cust_site_uses site,
2665: hz_cust_acct_sites acct_site,
2666: hz_party_sites party_site,
2667: hz_locations loc,

Line 2821: ar_payment_schedules ps,

2817: ext.payment_schedule_id,
2818: ext.amt_due_remaining,
2819: 'CTLGD' source_identifier
2820: from ar_aging_extract ext,
2821: ar_payment_schedules ps,
2822: ra_cust_trx_line_gl_dist ctlgd
2823: where ext.parent_request_id = pg_parent_request_id
2824: and ext.worker_id = pg_worker_id
2825: and ext.payment_schedule_id = ps.payment_schedule_id