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.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_PAYSCH_MERGE_GT

Line 4645: g_state := 'Populating FII_AR_PAYSCH_MERGE_GT';

4641: FII_UTIL.print_timer('Duration');
4642: FII_UTIL.put_line('');
4643: end if;
4644:
4645: g_state := 'Populating FII_AR_PAYSCH_MERGE_GT';
4646: if g_debug_flag = 'Y' then
4647: FII_UTIL.put_line(g_state);
4648: FII_UTIL.start_timer;
4649: FII_UTIL.put_line('');

Line 4652: insert into FII_AR_PAYSCH_MERGE_GT

4648: FII_UTIL.start_timer;
4649: FII_UTIL.put_line('');
4650: end if;
4651:
4652: insert into FII_AR_PAYSCH_MERGE_GT
4653: (
4654: class,
4655: org_id,
4656: invoice_currency_code,

Line 4731: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_PAYSCH_MERGE_GT');

4727: and CLASS IN ('INV', 'DM', 'CB', 'CM', 'DEP', 'BR', 'PMT');
4728: --and decode(g_collection_criteria, 'GL', gl_date, trx_date) >= g_global_start_date;
4729:
4730: if g_debug_flag = 'Y' then
4731: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_PAYSCH_MERGE_GT');
4732: FII_UTIL.stop_timer;
4733: FII_UTIL.print_timer('Duration');
4734: FII_UTIL.put_line('');
4735: end if;

Line 4826: FROM FII_AR_PAYSCH_MERGE_GT sch

4822: SELECT /*+ no_merge parallel(sch) */ DISTINCT
4823: sch.invoice_currency_code tc_code,
4824: sch.org_id,
4825: trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) conversion_date
4826: FROM FII_AR_PAYSCH_MERGE_GT sch
4827: --WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR','PMT')
4828: --AND sch.trx_date >= g_global_start_date
4829: ) v,
4830: ar_system_parameters_all par,

Line 5043: FROM FII_AR_PAYSCH_MERGE_GT sch,

5039: g_fii_user_id CREATED_BY,
5040: sysdate LAST_UPDATE_DATE,
5041: g_fii_user_id LAST_UPDATED_BY,
5042: g_fii_login_id LAST_UPDATE_LOGIN
5043: FROM FII_AR_PAYSCH_MERGE_GT sch,
5044: RA_CUSTOMER_TRX_ALL trx,
5045: FII_AR_CURR_RATES_T rt,
5046: AR_SYSTEM_PARAMETERS_ALL par,
5047: GL_SETS_OF_BOOKS sob

Line 5356: -- FII_AR_PMT_SCHEDULES_F sch, --> FII_AR_PAYSCH_MERGE_GT

5352: -- where start_date >= g_global_start_date
5353: -- and last_update_date <= g_sysdate_time
5354: ) */
5355: FII_AR_DISP_UPDATE_GT dis,
5356: -- FII_AR_PMT_SCHEDULES_F sch, --> FII_AR_PAYSCH_MERGE_GT
5357: ( select
5358: actual_date_closed,
5359: sch.customer_id bill_to_customer_id,
5360: sch.customer_site_use_id bill_to_site_use_id,

Line 5370: from FII_AR_PAYSCH_MERGE_GT sch

5366: invoice_currency_code,
5367: org_id,
5368: payment_schedule_id,
5369: trx_date
5370: from FII_AR_PAYSCH_MERGE_GT sch
5371: ) sch,
5372: FII_AR_CURR_RATES_T rt,
5373: AR_SYSTEM_PARAMETERS_ALL par,
5374: GL_SETS_OF_BOOKS sob

Line 5592: -- FII_AR_PMT_SCHEDULES_F sch --> FII_AR_PAYSCH_MERGE_GT

5588: where CLASS <> 'PMT'
5589: -- and decode(g_collection_criteria, 'GL', gl_date, trx_date) >= g_global_start_date
5590: )
5591: ) trx,
5592: -- FII_AR_PMT_SCHEDULES_F sch --> FII_AR_PAYSCH_MERGE_GT
5593: ( select
5594: NVL(ROUND(sch.amount_due_original * nvl(sch.exchange_rate,1) /
5595: rt.functional_mau) * rt.functional_mau,
5596: nvl(sch.amount_due_original,0)) amount_due_original_func,

Line 5613: from FII_AR_PAYSCH_MERGE_GT sch,

5609: sch.amount_due_original amount_due_original_trx,
5610: class,
5611: customer_trx_id,
5612: gl_date
5613: from FII_AR_PAYSCH_MERGE_GT sch,
5614: FII_AR_CURR_RATES_T rt,
5615: AR_SYSTEM_PARAMETERS_ALL par,
5616: GL_SETS_OF_BOOKS sob
5617: WHERE sch.org_id = par.org_id

Line 6288: FII_AR_PMT_SCHEDULES_F rctsch, --> FII_AR_PAYSCH_MERGE_GT

6284: created_by,
6285: creation_date,
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,

Line 6325: from -- FII_AR_PMT_SCHEDULES_F trxsch, --> FII_AR_PAYSCH_MERGE_GT

6321: trxsch.trx_date, --trx_date
6322: trxsch.due_date, --due_date
6323: trxsch.bill_to_customer_id,
6324: trxsch.bill_to_site_use_id
6325: from -- FII_AR_PMT_SCHEDULES_F trxsch, --> FII_AR_PAYSCH_MERGE_GT
6326: ( select
6327: sch.customer_id bill_to_customer_id,
6328: sch.customer_site_use_id bill_to_site_use_id,
6329: due_date,

Line 6336: from FII_AR_PAYSCH_MERGE_GT sch

6332: payment_schedule_id,
6333: trx_date,
6334: org_id,
6335: nvl(sch.exchange_date, sch.trx_date) exchange_date
6336: from FII_AR_PAYSCH_MERGE_GT sch
6337: ) trxsch,
6338: FII_AR_CURR_RATES_T trxrt,
6339: AR_SYSTEM_PARAMETERS_ALL par,
6340: GL_SETS_OF_BOOKS sob

Line 7687: fii_ar_paysch_merge_gt gt

7683: 'Transaction' action,
7684: sch.actual_date_closed
7685: from fii_ar_pmt_schedules_f sch,
7686: fii_ar_dso_setup dso,
7687: fii_ar_paysch_merge_gt gt
7688: where sch.class <> 'PMT'
7689: and dso.dso_group='TC'
7690: and dso.dso_type = sch.class
7691: and sch.customer_trx_id = gt.customer_trx_id

Line 7758: FII_AR_PAYSCH_MERGE_GT gt

7754: 'Application' action,
7755: sch.actual_date_closed
7756: from fii_ar_receipts_f rct,
7757: fii_ar_pmt_schedules_f sch,
7758: FII_AR_PAYSCH_MERGE_GT gt
7759: where rct.application_status = 'APP'
7760: and sch.class <> 'PMT'
7761: and rct.applied_payment_schedule_id = sch.payment_schedule_id
7762: and rct.applied_customer_trx_id = gt.customer_trx_id

Line 7806: FII_AR_PAYSCH_MERGE_GT gt

7802: from fii_ar_adjustments_f adj,
7803: fii_ar_pmt_schedules_f sch,
7804: fii_ar_dso_setup schdso,
7805: fii_ar_dso_setup adjdso,
7806: FII_AR_PAYSCH_MERGE_GT gt
7807: where adj.payment_schedule_id = sch.payment_schedule_id
7808: and sch.class <> 'PMT'
7809: and schdso.dso_group='TC'
7810: and schdso.dso_type = sch.class

Line 8907: from fii_ar_paysch_merge_gt gt,

8903: union all
8904:
8905: --Case 3
8906: select null payment_schedule_id, gt.customer_trx_id, gt.actual_date_closed min_date
8907: from fii_ar_paysch_merge_gt gt,
8908: fii_ar_aging_disputes ag
8909: where ag.payment_schedule_id = gt.payment_schedule_id
8910: and ag.event_date >= gt.actual_date_closed
8911:

Line 8966: -- Corresponding customer_trx_id(s) are populated in FII_AR_PAYSCH_MERGE_GT

8962: -- Purpose
8963: -- This procedure detects new/updated receipts and adjustments.
8964: -- It also detects records in fii_ar_aging_receivables that have not been
8965: -- completely aged.
8966: -- Corresponding customer_trx_id(s) are populated in FII_AR_PAYSCH_MERGE_GT
8967: ------------------------------------------------------------------
8968: PROCEDURE POPULATE_INCREMENTAL_IDS IS
8969:
8970: BEGIN

Line 8972: g_state := 'Populating FII_AR_PAYSCH_MERGE_GT from fii_ar_aging_receivables';

8968: PROCEDURE POPULATE_INCREMENTAL_IDS IS
8969:
8970: BEGIN
8971:
8972: g_state := 'Populating FII_AR_PAYSCH_MERGE_GT from fii_ar_aging_receivables';
8973: if g_debug_flag = 'Y' then
8974: FII_UTIL.put_line(g_state);
8975: end if;
8976:

Line 8977: --FII_AR_PAYSCH_MERGE_GT already contains:

8973: if g_debug_flag = 'Y' then
8974: FII_UTIL.put_line(g_state);
8975: end if;
8976:
8977: --FII_AR_PAYSCH_MERGE_GT already contains:
8978: --trx_ids of new payment schedules
8979: --trx_ids that have new applications
8980: --trx_ids that have new or updated adjustments
8981:

Line 8983: INSERT INTO FII_AR_PAYSCH_MERGE_GT

8979: --trx_ids that have new applications
8980: --trx_ids that have new or updated adjustments
8981:
8982: --Insert trx ids that are already in aging table but not yet aged completely
8983: INSERT INTO FII_AR_PAYSCH_MERGE_GT
8984: (customer_trx_id)
8985: (select distinct ag.customer_trx_id
8986: from fii_ar_aging_receivables ag
8987: where ag.next_aging_date > G_LAST_UPDATE_DATE --'15-APR-2005'

Line 8991: from fii_ar_paysch_merge_gt t

8987: where ag.next_aging_date > G_LAST_UPDATE_DATE --'15-APR-2005'
8988: and ag.next_aging_date <= g_sysdate --'20-MAY-2005'
8989: and not exists
8990: (select 1
8991: from fii_ar_paysch_merge_gt t
8992: where t.customer_trx_id = ag.customer_trx_id));
8993:
8994: if g_debug_flag = 'Y' then
8995: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_PAYSCH_MERGE_GT.');

Line 8995: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_PAYSCH_MERGE_GT.');

8991: from fii_ar_paysch_merge_gt t
8992: where t.customer_trx_id = ag.customer_trx_id));
8993:
8994: if g_debug_flag = 'Y' then
8995: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_PAYSCH_MERGE_GT.');
8996: FII_UTIL.stop_timer;
8997: FII_UTIL.print_timer('Duration');
8998: FII_UTIL.put_line('');
8999: end if;