APPS.FII_AP_INV_SUM_INIT dependencies on FII_AP_DUE_COUNTS_B

Line 6059: Steps to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B:

6055: FII_UTIL.put_line(g_state);
6056: end if;
6057:
6058: /* **************************************************************************
6059: Steps to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B:
6060:
6061: 1. To determine the action_date that a payment schedule enters
6062: and exits a bucket, if it enters a bucket at all, we need to know
6063: the creation date, due date,and fully paid date of each payment

Line 6094: To populate FII_AP_DUE_COUNTS_B, group by invoice_id and

6090: 01-01-2004 2 2
6091: 01-15-2004 -1 1
6092: 01-31-2004 -1 0
6093:
6094: To populate FII_AP_DUE_COUNTS_B, group by invoice_id and
6095: action_date and keep a cumulative sum for all due buckets and all
6096: past due buckets.
6097:
6098: 5. The most outer subquery looks at the cumulative sum of the

Line 6111: Bucket or Past Due Bucket Counts. Populate FII_AP_DUE_COUNTS_B

6107: 01-15-2004 0
6108: 01-31-2004 -1
6109:
6110: 6. Populate FII_AP_AGING_BKTS_B with those records with non-zero Due
6111: Bucket or Past Due Bucket Counts. Populate FII_AP_DUE_COUNTS_B
6112: with those records with non-zero Due or Past Due Counts.
6113: ************************************************************************** */
6114:
6115: g_state := 'Deleting records from FII_AP_INV_BUCKETS that are already existing';

Line 6125: TRUNCATE_TABLE('MLOG$_FII_AP_DUE_COUNTS_B');

6121:
6122: /* For Initial Load we will truncate the data in the count table
6123: and re-populate this table */
6124: TRUNCATE_TABLE('MLOG$_FII_AP_AGING_BKTS_B');
6125: TRUNCATE_TABLE('MLOG$_FII_AP_DUE_COUNTS_B');
6126:
6127: TRUNCATE_TABLE('FII_AP_AGING_BKTS_B');
6128: TRUNCATE_TABLE('FII_AP_DUE_COUNTS_B');
6129:

Line 6128: TRUNCATE_TABLE('FII_AP_DUE_COUNTS_B');

6124: TRUNCATE_TABLE('MLOG$_FII_AP_AGING_BKTS_B');
6125: TRUNCATE_TABLE('MLOG$_FII_AP_DUE_COUNTS_B');
6126:
6127: TRUNCATE_TABLE('FII_AP_AGING_BKTS_B');
6128: TRUNCATE_TABLE('FII_AP_DUE_COUNTS_B');
6129:
6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';
6131: if g_debug_flag = 'Y' then
6132: FII_UTIL.put_line(g_state);

Line 6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';

6126:
6127: TRUNCATE_TABLE('FII_AP_AGING_BKTS_B');
6128: TRUNCATE_TABLE('FII_AP_DUE_COUNTS_B');
6129:
6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';
6131: if g_debug_flag = 'Y' then
6132: FII_UTIL.put_line(g_state);
6133: FII_UTIL.start_timer;
6134: FII_UTIL.put_line('');

Line 6138: INSERT /*+ append parallel(fii_ap_aging_bkts_b) parallel(fii_ap_due_counts_b) */ ALL

6134: FII_UTIL.put_line('');
6135: end if;
6136:
6137:
6138: INSERT /*+ append parallel(fii_ap_aging_bkts_b) parallel(fii_ap_due_counts_b) */ ALL
6139: WHEN ( Due_Bucket1_Cnt <> 0
6140: OR Due_Bucket2_Cnt <> 0
6141: OR Due_Bucket3_Cnt <> 0
6142: OR Past_Due_Bucket1_Cnt <> 0

Line 6183: THEN INTO FII_AP_DUE_COUNTS_B (

6179: sysdate,
6180: g_fii_login_id)
6181: WHEN ( Due_Cnt <> 0
6182: OR Past_Due_Cnt <> 0)
6183: THEN INTO FII_AP_DUE_COUNTS_B (
6184: Time_ID,
6185: Period_Type_ID,
6186: Org_ID,
6187: Supplier_ID,

Line 6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');

6433: COMMIT;
6434:
6435:
6436: if g_debug_flag = 'Y' then
6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');
6438: FII_UTIL.stop_timer;
6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;

Line 6443: -- g_state := 'Truncating temp tables used to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B';

6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;
6442:
6443: -- g_state := 'Truncating temp tables used to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B';
6444: -- TRUNCATE_TABLE('FII_AP_BUCKET_CALCS');
6445: -- TRUNCATE_TABLE('FII_AP_PS_BUCKETS');
6446: -- TRUNCATE_TABLE('FII_AP_INDEX_TEMP');
6447: