APPS.FII_AR_FACTS_AGING_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 561: AR_RECEIVABLE_APPLICATIONS_ALL app,

557: sch.invoice_currency_code tc_code,
558: sch.org_id,
559: trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) conversion_date
560: FROM AR_PAYMENT_SCHEDULES_ALL sch,
561: AR_RECEIVABLE_APPLICATIONS_ALL app,
562: AR_PAYMENT_SCHEDULES_ALL trxsch
563: WHERE sch.class = 'PMT'
564: AND sch.payment_schedule_id = app.payment_schedule_id
565: AND app.applied_customer_trx_id = trxsch.customer_trx_id

Line 1060: AR_RECEIVABLE_APPLICATIONS_ALL app,

1056: sysdate, --LAST_UPDATE_DATE,
1057: g_fii_user_id, --LAST_UPDATED_BY,
1058: g_fii_login_id --LAST_UPDATE_LOGIN
1059: FROM AR_PAYMENT_SCHEDULES_ALL sch,
1060: AR_RECEIVABLE_APPLICATIONS_ALL app,
1061: AR_PAYMENT_SCHEDULES_ALL trxsch,
1062: FII_AR_CURR_RATES_T rt,
1063: AR_SYSTEM_PARAMETERS_ALL par,
1064: GL_SETS_OF_BOOKS sob

Line 1774: from AR_RECEIVABLE_APPLICATIONS_ALL app) app,

1770: PAYMENT_SCHEDULE_ID,
1771: created_by,
1772: creation_date,
1773: org_id
1774: from AR_RECEIVABLE_APPLICATIONS_ALL app) app,
1775:
1776: FII_AR_PMT_SCHEDULES_F rctsch,
1777:
1778: (select /*+ parallel(RCT) parallel(RCTRT) parallel(SOB) */

Line 1851: and exists (select 'x' from ar_receivable_applications_all app2

1847: then 1
1848: when decode(g_collection_criteria,
1849: 'GL', rct_gl_date,
1850: rct.receipt_date) < g_global_start_date
1851: and exists (select 'x' from ar_receivable_applications_all app2
1852: where app2.cash_receipt_id = app.cash_receipt_id
1853: and decode(g_global_start_date,
1854: 'GL', app2.gl_date,
1855: app2.apply_date) >= g_global_start_date

Line 4369: ar_receivable_applications_all app,

4365: , sch.class
4366: , sch.gl_date
4367: , sch.trx_date
4368: from ar_payment_schedules_all sch,
4369: ar_receivable_applications_all app,
4370: ar_payment_schedules_all trxsch
4371: where sch.PAYMENT_SCHEDULE_ID > G_MAX_PAYMENT_SCHEDULE_ID
4372: and sch.class in ('PMT')
4373: and decode(g_collection_criteria, 'GL', sch.gl_date, sch.trx_date) <

Line 4535: from ar_receivable_applications_all app

4531: , EARNED_DISCOUNT_TAKEN
4532: , acctd_earned_discount_taken
4533: , UNEARNED_DISCOUNT_TAKEN
4534: , acctd_unearned_discount_taken
4535: from ar_receivable_applications_all app
4536: -- To calculate rct_gl_date
4537: where exists (select 'x' from ar_receivable_applications_all app2
4538: where app2.RECEIVABLE_APPLICATION_ID > G_MAX_RECEIVABLE_APPL_ID
4539: and app2.cash_receipt_id = app.cash_receipt_id

Line 4537: where exists (select 'x' from ar_receivable_applications_all app2

4533: , UNEARNED_DISCOUNT_TAKEN
4534: , acctd_unearned_discount_taken
4535: from ar_receivable_applications_all app
4536: -- To calculate rct_gl_date
4537: where exists (select 'x' from ar_receivable_applications_all app2
4538: where app2.RECEIVABLE_APPLICATION_ID > G_MAX_RECEIVABLE_APPL_ID
4539: and app2.cash_receipt_id = app.cash_receipt_id
4540:
4541: and (app2.status in ('APP', 'ACTIVITY')

Line 4567: from ar_receivable_applications_all app

4563: , EARNED_DISCOUNT_TAKEN
4564: , acctd_earned_discount_taken
4565: , UNEARNED_DISCOUNT_TAKEN
4566: , acctd_unearned_discount_taken
4567: from ar_receivable_applications_all app
4568: -- To calculate rct_gl_date
4569: where exists (select 'x' from ar_receivable_applications_all app2
4570: where app2.RECEIVABLE_APPLICATION_ID > G_MAX_RECEIVABLE_APPL_ID
4571: and app2.customer_trx_id = app.customer_trx_id

Line 4569: where exists (select 'x' from ar_receivable_applications_all app2

4565: , UNEARNED_DISCOUNT_TAKEN
4566: , acctd_unearned_discount_taken
4567: from ar_receivable_applications_all app
4568: -- To calculate rct_gl_date
4569: where exists (select 'x' from ar_receivable_applications_all app2
4570: where app2.RECEIVABLE_APPLICATION_ID > G_MAX_RECEIVABLE_APPL_ID
4571: and app2.customer_trx_id = app.customer_trx_id
4572: and application_type = 'CM')
4573: ;