APPS.FII_AP_INV_SUM_INIT dependencies on FII_AP_PAY_CHK_STG

Line 759: g_state := 'Inserting records into the FII_AP_PAY_CHK_STG table';

755: Procedure INSERT_PAYMENT_CHECK_INFO IS
756:
757: BEGIN
758:
759: g_state := 'Inserting records into the FII_AP_PAY_CHK_STG table';
760: if g_debug_flag = 'Y' then
761: FII_UTIL.put_line('');
762: FII_UTIL.put_line(g_state);
763: fii_util.start_timer;

Line 768: INSERT /*+ append parallel(S) */ INTO FII_AP_PAY_CHK_STG S

764: fii_util.put_line('');
765: end if;
766:
767:
768: INSERT /*+ append parallel(S) */ INTO FII_AP_PAY_CHK_STG S
769: (Invoice_ID,
770: Payment_Num,
771: Check_Date,
772: Payment_Amount,

Line 805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');

801: AND AC.Check_ID = AIP.Check_ID
802: AND AC.Void_Date IS NULL;
803:
804: if g_debug_flag = 'Y' then
805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');
806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:

Line 810: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PAY_CHK_STG');

806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:
810: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PAY_CHK_STG');
811: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
812:
813: COMMIT;
814:

Line 1865: FII_AP_PAY_CHK_STG APC,

1861: AIP_PP.Discount_Taken,
1862: AIP_PP.Check_ID,
1863: AIP_PP.WH_Tax_Amount,
1864: AIP_PP.Invoice_Payment_ID) AIP,
1865: FII_AP_PAY_CHK_STG APC,
1866: AP_Checks_All AC,
1867: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
1868: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1869: WHERE AI.Invoice_ID = PS.Invoice_ID

Line 2129: FII_AP_PAY_CHK_STG APC,

2125: AIP_PP.Discount_Taken,
2126: AIP_PP.Check_ID,
2127: AIP_PP.WH_Tax_Amount,
2128: AIP_PP.Invoice_Payment_ID) AIP,
2129: FII_AP_PAY_CHK_STG APC,
2130: AP_Checks_All AC,
2131: -- IBY_Payment_Profiles IBYPM
2132: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
2133: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE

Line 3258: FII_AP_Pay_Chk_Stg APC

3254: NVL(SUM(CASE WHEN APC.Invp_Creation_Date IS NOT NULL
3255: AND APC.Invp_Creation_Date <= APS1.Creation_Date
3256: THEN APC.Payment_Amount ELSE 0 END),0) Pay_Amount
3257: FROM FII_AP_Prepay_T APS1,
3258: FII_AP_Pay_Chk_Stg APC
3259: WHERE APS1.Invoice_ID BETWEEN g_start_range and g_end_range
3260: AND APS1.Invoice_ID = APC.Invoice_ID (+)
3261: AND APS1.Payment_Num = APC.Payment_Num (+)
3262: Group By APS1.Invoice_ID,

Line 3574: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

3570: AND PREP.Creation_Date < TRUNC(PREP.Discount_Date) + 1
3571: GROUP BY PREP.Invoice_ID,
3572: PREP.Payment_Num,
3573: PREP.Discount_Date) PP,
3574: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
3575: PC.Payment_Num,
3576: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
3577: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
3578: FROM FII_AP_PAY_CHK_STG PC

Line 3578: FROM FII_AP_PAY_CHK_STG PC

3574: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
3575: PC.Payment_Num,
3576: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
3577: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
3578: FROM FII_AP_PAY_CHK_STG PC
3579: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
3580: AND PC.Invoice_Type <> 'PREPAYMENT'
3581: AND TRUNC(PC.Discount_Date) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
3582: AND PC.Invp_Creation_Date < TRUNC(PC.Discount_Date) + 1

Line 3837: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

3833: AND PREP.Creation_Date < PREP.Second_Discount_Date + 1
3834: GROUP BY PREP.Invoice_ID,
3835: PREP.Payment_Num,
3836: PREP.Second_Discount_Date) PP,
3837: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
3838: PC.Payment_Num,
3839: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
3840: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
3841: FROM FII_AP_PAY_CHK_STG PC

Line 3841: FROM FII_AP_PAY_CHK_STG PC

3837: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
3838: PC.Payment_Num,
3839: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
3840: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
3841: FROM FII_AP_PAY_CHK_STG PC
3842: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
3843: AND PC.Invoice_Type <> 'PREPAYMENT'
3844: AND PC.Second_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
3845: AND PC.Invp_Creation_Date < PC.Second_Discount_Date + 1

Line 3852: FROM FII_AP_PAY_CHK_STG PC

3848: PC.Second_Discount_Date) APC,
3849: (SELECT PC.Invoice_ID Invoice_ID,
3850: PC.Payment_Num Payment_Num,
3851: NVL(SUM(NVL(PC.Discount_Taken,0)),0) Discount_Taken
3852: FROM FII_AP_PAY_CHK_STG PC
3853: WHERE PC.Invoice_ID BETWEEN g_start_range and g_end_range
3854: AND PC.Second_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
3855: AND PC.Invp_Creation_Date BETWEEN PC.Discount_Date + 1 AND PC.Second_Discount_Date
3856: GROUP BY PC.Invoice_ID,

Line 4101: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

4097: AND PREP.Creation_Date < PREP.Third_Discount_Date + 1
4098: GROUP BY PREP.Invoice_ID,
4099: PREP.Payment_Num,
4100: PREP.Third_Discount_Date) PP,
4101: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4102: PC.Payment_Num,
4103: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
4104: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4105: FROM FII_AP_PAY_CHK_STG PC

Line 4105: FROM FII_AP_PAY_CHK_STG PC

4101: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4102: PC.Payment_Num,
4103: SUM(NVL(PC.Discount_Taken, 0)) Discount_Taken,
4104: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4105: FROM FII_AP_PAY_CHK_STG PC
4106: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
4107: AND PC.Invoice_Type <> 'PREPAYMENT'
4108: AND PC.Third_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
4109: AND PC.Invp_Creation_Date < PC.Third_Discount_Date + 1

Line 4116: FROM FII_AP_PAY_CHK_STG PC

4112: PC.Third_Discount_Date) APC,
4113: (SELECT PC.Invoice_ID Invoice_ID,
4114: PC.Payment_Num Payment_Num,
4115: NVL(SUM(NVL(PC.Discount_Taken,0)),0) Discount_Taken
4116: FROM FII_AP_PAY_CHK_STG PC
4117: WHERE PC.Invoice_ID BETWEEN g_start_range and g_end_range
4118: AND PC.Third_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
4119: AND PC.Invp_Creation_Date BETWEEN PC.Second_Discount_Date + 1
4120: AND PC.Third_Discount_Date

Line 4436: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

4432: AND TRUNC(PREP.Creation_Date) < TRUNC(PREP.Due_Date) + 1
4433: GROUP BY PREP.Invoice_ID,
4434: PREP.Payment_Num,
4435: PREP.Due_Date) PP,
4436: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4437: PC.Payment_Num,
4438: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4439: FROM FII_AP_PAY_CHK_STG PC
4440: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range

Line 4439: FROM FII_AP_PAY_CHK_STG PC

4435: PREP.Due_Date) PP,
4436: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4437: PC.Payment_Num,
4438: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4439: FROM FII_AP_PAY_CHK_STG PC
4440: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
4441: AND PC.Invoice_Type <> 'PREPAYMENT'
4442: AND PC.Due_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date, g_sysdate)
4443: AND PC.Due_Date >= PC.Entered_Date

Line 4739: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

4735: AND PREP.Creation_Date < (PREP.Due_Date - g_due_bucket2)
4736: GROUP BY PREP.Invoice_ID,
4737: PREP.Payment_Num,
4738: PREP.Due_Date) PP,
4739: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4740: PC.Payment_Num,
4741: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4742: FROM FII_AP_PAY_CHK_STG PC
4743: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range

Line 4742: FROM FII_AP_PAY_CHK_STG PC

4738: PREP.Due_Date) PP,
4739: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
4740: PC.Payment_Num,
4741: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
4742: FROM FII_AP_PAY_CHK_STG PC
4743: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
4744: AND PC.Invoice_Type <> 'PREPAYMENT'
4745: AND (PC.Due_Date - g_due_bucket2) BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
4746: AND PC.Invp_Creation_Date < (PC.Due_Date - g_due_bucket2)

Line 5014: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

5010: AND PREP.Creation_Date < (PREP.Due_Date - g_due_bucket3)
5011: GROUP BY PREP.Invoice_ID,
5012: PREP.Payment_Num,
5013: PREP.Due_Date) PP,
5014: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5015: PC.Payment_Num,
5016: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5017: FROM FII_AP_PAY_CHK_STG PC
5018: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range

Line 5017: FROM FII_AP_PAY_CHK_STG PC

5013: PREP.Due_Date) PP,
5014: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5015: PC.Payment_Num,
5016: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5017: FROM FII_AP_PAY_CHK_STG PC
5018: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
5019: AND PC.Invoice_Type <> 'PREPAYMENT'
5020: AND (PC.Due_Date - g_due_bucket3) BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5021: AND PC.Invp_Creation_Date < (PC.Due_Date - g_due_bucket3)

Line 5316: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

5312: AND PREP.Creation_Date < (PREP.Due_Date + g_past_bucket3) + 1
5313: GROUP BY PREP.Invoice_ID,
5314: PREP.Payment_Num,
5315: PREP.Due_Date) PP,
5316: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5317: PC.Payment_Num,
5318: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5319: FROM FII_AP_PAY_CHK_STG PC
5320: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range

Line 5319: FROM FII_AP_PAY_CHK_STG PC

5315: PREP.Due_Date) PP,
5316: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5317: PC.Payment_Num,
5318: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5319: FROM FII_AP_PAY_CHK_STG PC
5320: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
5321: AND PC.Invoice_Type <> 'PREPAYMENT'
5322: AND (PC.Due_Date + g_past_bucket3) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5323: AND PC.Invp_Creation_Date < (PC.Due_Date + g_past_bucket3) + 1

Line 5589: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,

5585: AND PREP.Creation_Date < (PREP.Due_Date + g_past_bucket2) + 1
5586: GROUP BY PREP.Invoice_ID,
5587: PREP.Payment_Num,
5588: PREP.Due_Date) PP,
5589: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5590: PC.Payment_Num,
5591: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5592: FROM FII_AP_PAY_CHK_STG PC
5593: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range

Line 5592: FROM FII_AP_PAY_CHK_STG PC

5588: PREP.Due_Date) PP,
5589: (SELECT /*+ index(PC,FII_AP_PAY_CHK_STG_N1) */ PC.Invoice_ID,
5590: PC.Payment_Num,
5591: SUM(NVL(PC.Payment_Amount, 0)) Payment_Amount
5592: FROM FII_AP_PAY_CHK_STG PC
5593: WHERE PC.Invoice_id BETWEEN g_start_range and g_end_range
5594: AND PC.Invoice_Type <> 'PREPAYMENT'
5595: AND (PC.Due_Date + g_past_bucket2) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5596: AND PC.Invp_Creation_Date < (PC.Due_Date + g_past_bucket2) + 1

Line 7036: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');

7032: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7033: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7034: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7035: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7036: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');
7037:
7038: COMMIT;
7039:
7040: if g_debug_flag = 'Y' then

Line 7209: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');

7205: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7206: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7207: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7208: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7209: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');
7210:
7211: END IF;
7212:
7213: