DBA Data[Home] [Help]

APPS.FII_AR_FACTS_AGING_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 547: FROM AR_PAYMENT_SCHEDULES_ALL sch

543: SELECT /*+ no_merge parallel(sch) */ DISTINCT
544: sch.invoice_currency_code tc_code,
545: sch.org_id,
546: trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) conversion_date
547: FROM AR_PAYMENT_SCHEDULES_ALL sch
548: WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR','PMT')
549: AND decode(g_collection_criteria,
550: 'GL', sch.gl_date,
551: sch.trx_date) >= g_global_start_date

Line 560: FROM AR_PAYMENT_SCHEDULES_ALL sch,

556: SELECT DISTINCT
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

Line 562: AR_PAYMENT_SCHEDULES_ALL trxsch

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
566: AND app.status = 'APP'

Line 916: FROM AR_PAYMENT_SCHEDULES_ALL sch,

912: g_fii_user_id, --CREATED_BY,
913: sysdate, --LAST_UPDATE_DATE,
914: g_fii_user_id, --LAST_UPDATED_BY,
915: g_fii_login_id --LAST_UPDATE_LOGIN
916: FROM AR_PAYMENT_SCHEDULES_ALL sch,
917: RA_CUSTOMER_TRX_ALL trx,
918: FII_AR_CURR_RATES_T rt,
919: AR_SYSTEM_PARAMETERS_ALL par,
920: GL_SETS_OF_BOOKS sob,

Line 1059: FROM AR_PAYMENT_SCHEDULES_ALL sch,

1055: g_fii_user_id, --CREATED_BY,
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,

Line 1061: AR_PAYMENT_SCHEDULES_ALL trxsch,

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
1065: WHERE sch.class = 'PMT'

Line 4355: from ar_payment_schedules_all

4351: , CUSTOMER_TRX_ID
4352: , class
4353: , gl_date
4354: , trx_date
4355: from ar_payment_schedules_all
4356: where PAYMENT_SCHEDULE_ID > G_MAX_PAYMENT_SCHEDULE_ID
4357: and class in ('INV', 'DM', 'CB', 'CM', 'DEP', 'BR', 'PMT')
4358: and decode(g_collection_criteria, 'GL', gl_date, trx_date) >=
4359: g_global_start_date

Line 4368: from ar_payment_schedules_all sch,

4364: , sch.CUSTOMER_TRX_ID
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')

Line 4370: ar_payment_schedules_all trxsch

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) <
4374: g_global_start_date

Line 4612: from ar_payment_schedules_all

4608: -- PaySch Delete 2
4609: /*
4610: insert into FII_AR_PAYSCH_DELETE_PAYSCH_GT
4611: select CUSTOMER_TRX_ID
4612: from ar_payment_schedules_all
4613: where PAYMENT_SCHEDULE_ID > G_MAX_PAYMENT_SCHEDULE_ID;
4614: */
4615:
4616: g_state := 'Populating FII_AR_RECAPP_DELETE_GT';

Line 4705: from ar_payment_schedules_all

4701: , status
4702: , term_id
4703: , terms_sequence_number
4704: , created_by
4705: from ar_payment_schedules_all
4706: where PAYMENT_SCHEDULE_ID in (
4707: -- PaySch Insert
4708: select PAYMENT_SCHEDULE_ID
4709: from FII_AR_PAYSCH_INSERT_GT

Line 6290: -- a join to AR_PAYMENT_SCHEDULES_ALL

6286: org_id
6287: from FII_AR_RECAPP_INSERT_GT) app,
6288: FII_AR_PMT_SCHEDULES_F rctsch, --> FII_AR_PAYSCH_MERGE_GT
6289: -- previous_customer_trx_id needs
6290: -- a join to AR_PAYMENT_SCHEDULES_ALL
6291: (select rct.cash_receipt_id,
6292: rct.status,
6293: rct.currency_code,
6294: nvl(rct.exchange_rate,1) exchange_rate,