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_PMT_SCHEDULES_F

Line 723: -- This procedure inserts records in FII_AR_PMT_SCHEDULES_F

719:
720: ------------------------------------------------------------------
721: -- Procedure POPULATE_PAYMENT_SCHEDULES
722: -- Purpose
723: -- This procedure inserts records in FII_AR_PMT_SCHEDULES_F
724: ------------------------------------------------------------------
725: PROCEDURE POPULATE_PAYMENT_SCHEDULES IS
726:
727: l_max_pmt_schedule_id NUMBER(15);

Line 731: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';

727: l_max_pmt_schedule_id NUMBER(15);
728:
729: BEGIN
730:
731: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
732: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
733:
734: g_state := 'Populating FII_AR_PMT_SCHEDULES_F';
735: if g_debug_flag = 'Y' then

Line 732: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');

728:
729: BEGIN
730:
731: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
732: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
733:
734: g_state := 'Populating FII_AR_PMT_SCHEDULES_F';
735: if g_debug_flag = 'Y' then
736: FII_UTIL.put_line(g_state);

Line 734: g_state := 'Populating FII_AR_PMT_SCHEDULES_F';

730:
731: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
732: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
733:
734: g_state := 'Populating FII_AR_PMT_SCHEDULES_F';
735: if g_debug_flag = 'Y' then
736: FII_UTIL.put_line(g_state);
737: FII_UTIL.start_timer;
738: FII_UTIL.put_line('');

Line 742: INSERT /+ append parallel(F) / INTO FII_AR_PMT_SCHEDULES_F F

738: FII_UTIL.put_line('');
739: end if;
740:
741:
742: INSERT /*+ append parallel(F) */ INTO FII_AR_PMT_SCHEDULES_F F
743: (payment_schedule_id,
744: time_id,
745: class,
746: amount_due_original_trx,

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

1079: AND trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) = rt.conversion_date;
1080:
1081:
1082: if g_debug_flag = 'Y' then
1083: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_PMT_SCHEDULES_F');
1084: FII_UTIL.stop_timer;
1085: FII_UTIL.print_timer('Duration');
1086: FII_UTIL.put_line('');
1087: end if;

Line 1089: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';

1085: FII_UTIL.print_timer('Duration');
1086: FII_UTIL.put_line('');
1087: end if;
1088:
1089: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
1090: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
1091:
1092: g_state := 'Logging maximum payment schedule id into fii_change_log table';
1093: select nvl(max(payment_schedule_id), -999)

Line 1090: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');

1086: FII_UTIL.put_line('');
1087: end if;
1088:
1089: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
1090: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
1091:
1092: g_state := 'Logging maximum payment schedule id into fii_change_log table';
1093: select nvl(max(payment_schedule_id), -999)
1094: into l_max_pmt_schedule_id

Line 1095: from fii_ar_pmt_schedules_f;

1091:
1092: g_state := 'Logging maximum payment schedule id into fii_change_log table';
1093: select nvl(max(payment_schedule_id), -999)
1094: into l_max_pmt_schedule_id
1095: from fii_ar_pmt_schedules_f;
1096:
1097: INSERT INTO fii_change_log
1098: (log_item, item_value, CREATION_DATE, CREATED_BY,
1099: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 1203: FII_AR_PMT_SCHEDULES_F sch,

1199: sysdate, --LAST_UPDATE_DATE,
1200: g_fii_user_id, --LAST_UPDATED_BY,
1201: g_fii_login_id --LAST_UPDATE_LOGIN
1202: FROM AR_DISPUTE_HISTORY dis,
1203: FII_AR_PMT_SCHEDULES_F sch,
1204: FII_AR_CURR_RATES_T rt,
1205: AR_SYSTEM_PARAMETERS_ALL par,
1206: GL_SETS_OF_BOOKS sob
1207: WHERE dis.payment_schedule_id = sch.payment_schedule_id

Line 1376: FII_AR_PMT_SCHEDULES_F sch

1372: sysdate, --LAST_UPDATE_DATE,
1373: g_fii_user_id, --LAST_UPDATED_BY,
1374: g_fii_login_id --LAST_UPDATE_LOGIN
1375: FROM ra_customer_trx_all trx,
1376: FII_AR_PMT_SCHEDULES_F sch
1377: WHERE trx.customer_trx_id = sch.customer_trx_id
1378: AND sch.class <> 'PMT'
1379: AND decode(g_collection_criteria,
1380: 'GL', sch.gl_date,

Line 1776: FII_AR_PMT_SCHEDULES_F rctsch,

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) */
1779: rct.cash_receipt_id,
1780: rct.status,

Line 1814: from FII_AR_PMT_SCHEDULES_F trxsch,

1810: trxsch.trx_date, --trx_date
1811: trxsch.due_date, --due_date
1812: trxsch.bill_to_customer_id,
1813: trxsch.bill_to_site_use_id
1814: from FII_AR_PMT_SCHEDULES_F trxsch,
1815: FII_AR_CURR_RATES_T trxrt,
1816: AR_SYSTEM_PARAMETERS_ALL par,
1817: GL_SETS_OF_BOOKS sob
1818: where trxsch.org_id = par.org_id

Line 3034: from fii_ar_pmt_schedules_f sch,

3030: null on_account_credit_flag, --no longer used after adding on_acct_credit_amount in bug 6053566
3031: decode(sch.class,'DEP','Y','N') unapplied_deposit_flag,
3032: 'Transaction' action,
3033: sch.actual_date_closed
3034: from fii_ar_pmt_schedules_f sch,
3035: fii_ar_dso_setup dso
3036: where sch.class <> 'PMT'
3037: and dso.dso_group='TC'
3038: and dso.dso_type = sch.class

Line 3106: fii_ar_pmt_schedules_f sch

3102: else 'N' end unapplied_deposit_flag,
3103: 'Application' action,
3104: sch.actual_date_closed
3105: from fii_ar_receipts_f rct,
3106: fii_ar_pmt_schedules_f sch
3107: where rct.application_status = 'APP'
3108: and sch.class <> 'PMT'
3109: and rct.applied_payment_schedule_id = sch.payment_schedule_id
3110:

Line 3151: fii_ar_pmt_schedules_f sch,

3147: decode(adj.adj_class,'DEP','Y','N') unapplied_deposit_flag,
3148: 'Adjustment' action,
3149: sch.actual_date_closed
3150: from fii_ar_adjustments_f adj,
3151: fii_ar_pmt_schedules_f sch,
3152: fii_ar_dso_setup schdso,
3153: fii_ar_dso_setup adjdso
3154: where adj.payment_schedule_id = sch.payment_schedule_id
3155: and sch.class <> 'PMT'

Line 4749: from fii_ar_pmt_schedules_f

4745: (
4746: payment_schedule_id
4747: )
4748: select PAYMENT_SCHEDULE_ID
4749: from fii_ar_pmt_schedules_f
4750: where CUSTOMER_TRX_ID in (
4751: -- PaySch Delete 1
4752: select CUSTOMER_TRX_ID
4753: from FII_AR_TRANS_DELETE_GT

Line 4881: -- This procedure manipulates records in FII_AR_PMT_SCHEDULES_F

4877:
4878: ------------------------------------------------------------------
4879: -- Procedure Inc_PAYMENT_SCHEDULES
4880: -- Purpose
4881: -- This procedure manipulates records in FII_AR_PMT_SCHEDULES_F
4882: ------------------------------------------------------------------
4883: PROCEDURE Inc_PAYMENT_SCHEDULES IS
4884:
4885: l_max_pmt_schedule_id NUMBER(15);

Line 4890: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';

4886:
4887: BEGIN
4888:
4889: /*
4890: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
4891: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
4892: */
4893:
4894: g_state := 'Deleting records from FII_AR_PMT_SCHEDULES_F';

Line 4891: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');

4887: BEGIN
4888:
4889: /*
4890: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
4891: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
4892: */
4893:
4894: g_state := 'Deleting records from FII_AR_PMT_SCHEDULES_F';
4895: if g_debug_flag = 'Y' then

Line 4894: g_state := 'Deleting records from FII_AR_PMT_SCHEDULES_F';

4890: g_state := 'Truncating table FII_AR_PMT_SCHEDULES_F';
4891: TRUNCATE_TABLE('FII_AR_PMT_SCHEDULES_F');
4892: */
4893:
4894: g_state := 'Deleting records from FII_AR_PMT_SCHEDULES_F';
4895: if g_debug_flag = 'Y' then
4896: FII_UTIL.put_line(g_state);
4897: FII_UTIL.start_timer;
4898: FII_UTIL.put_line('');

Line 4901: delete from fii_ar_pmt_schedules_f

4897: FII_UTIL.start_timer;
4898: FII_UTIL.put_line('');
4899: end if;
4900:
4901: delete from fii_ar_pmt_schedules_f
4902: where PAYMENT_SCHEDULE_ID in (
4903: -- PaySch Delete 1 2 3
4904: select PAYMENT_SCHEDULE_ID
4905: from FII_AR_PAYSCH_DELETE_GT

Line 4909: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_PMT_SCHEDULES_F');

4905: from FII_AR_PAYSCH_DELETE_GT
4906: );
4907:
4908: if g_debug_flag = 'Y' then
4909: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_PMT_SCHEDULES_F');
4910: FII_UTIL.stop_timer;
4911: FII_UTIL.print_timer('Duration');
4912: FII_UTIL.put_line('');
4913: end if;

Line 4917: g_state := 'Merging into FII_AR_PMT_SCHEDULES_F';

4913: end if;
4914:
4915: commit;
4916:
4917: g_state := 'Merging into FII_AR_PMT_SCHEDULES_F';
4918: if g_debug_flag = 'Y' then
4919: FII_UTIL.put_line(g_state);
4920: FII_UTIL.start_timer;
4921: FII_UTIL.put_line('');

Line 4924: merge into fii_ar_pmt_schedules_f old using (

4920: FII_UTIL.start_timer;
4921: FII_UTIL.put_line('');
4922: end if;
4923:
4924: merge into fii_ar_pmt_schedules_f old using (
4925: -- POPULATE_PAYMENT_SCHEDULES
4926: SELECT sch.payment_schedule_id,
4927: to_number(to_char(decode(g_collection_criteria,
4928: 'GL', sch.gl_date,

Line 5227: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_PMT_SCHEDULES_F');

5223: dlt.LAST_UPDATE_LOGIN
5224: );
5225:
5226: if g_debug_flag = 'Y' then
5227: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_PMT_SCHEDULES_F');
5228: FII_UTIL.stop_timer;
5229: FII_UTIL.print_timer('Duration');
5230: FII_UTIL.put_line('');
5231: end if;

Line 5233: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';

5229: FII_UTIL.print_timer('Duration');
5230: FII_UTIL.put_line('');
5231: end if;
5232:
5233: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
5234: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
5235:
5236: g_state := 'Logging maximum payment schedule id into fii_change_log table';
5237: select nvl(max(payment_schedule_id), -999)

Line 5234: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');

5230: FII_UTIL.put_line('');
5231: end if;
5232:
5233: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
5234: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
5235:
5236: g_state := 'Logging maximum payment schedule id into fii_change_log table';
5237: select nvl(max(payment_schedule_id), -999)
5238: into l_max_pmt_schedule_id

Line 5239: from fii_ar_pmt_schedules_f;

5235:
5236: g_state := 'Logging maximum payment schedule id into fii_change_log table';
5237: select nvl(max(payment_schedule_id), -999)
5238: into l_max_pmt_schedule_id
5239: from fii_ar_pmt_schedules_f;
5240:
5241: INSERT INTO fii_change_log
5242: (log_item, item_value, CREATION_DATE, CREATED_BY,
5243: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

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 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 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 7685: from fii_ar_pmt_schedules_f sch,

7681: null on_account_credit_flag,
7682: decode(sch.class,'DEP','Y','N') unapplied_deposit_flag,
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'

Line 7757: fii_ar_pmt_schedules_f sch,

7753: else 'N' end unapplied_deposit_flag,
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

Line 7803: fii_ar_pmt_schedules_f sch,

7799: decode(adj.adj_class,'DEP','Y','N') unapplied_deposit_flag,
7800: 'Adjustment' action,
7801: sch.actual_date_closed
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