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_AP_INV_SUM_INIT dependencies on FII_AP_WH_TAX_T

Line 508: g_state := 'Inserting records into the FII_AP_WH_TAX_T table';

504: Procedure INSERT_WH_PREPAY_AMOUNT IS
505:
506: BEGIN
507:
508: g_state := 'Inserting records into the FII_AP_WH_TAX_T table';
509: if g_debug_flag = 'Y' then
510: FII_UTIL.put_line('');
511: FII_UTIL.put_line(g_state);
512: fii_util.start_timer;

Line 521: INSERT /+ append parallel(T) / INTO fii_ap_wh_tax_t T

517: /* Selecting the prorated prepayment and withholding amount for a
518: payment schedule and inserting into the temp table */
519:
520:
521: INSERT /*+ append parallel(T) */ INTO fii_ap_wh_tax_t T
522: (Invoice_ID,
523: Payment_Num,
524: Creation_Date,
525: Due_Date,

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

577: FC.Minimum_Accountable_Unit;
578:
579:
580: if g_debug_flag = 'Y' then
581: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_WH_TAX_T');
582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:

Line 586: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_WH_TAX_T');

582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:
586: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_WH_TAX_T');
587: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
588:
589: COMMIT;
590:

Line 709: FROM FII_AP_WH_TAX_T STG

705: GROUP BY AIP.Invoice_ID, AIP.Payment_Num) PAY,
706: (SELECT /*+ parallel(STG) */ Invoice_ID,
707: Payment_Num,
708: SUM(WH_Tax_Amount) WH_Tax_Amount
709: FROM FII_AP_WH_TAX_T STG
710: GROUP BY Invoice_ID, Payment_Num) TEMP
711: WHERE PS.Invoice_ID = PAY.Invoice_ID (+)
712: AND PS.Payment_Num = PAY.Payment_Num (+)
713: AND PS.Invoice_ID = TEMP.Invoice_ID (+)

Line 1841: FII_AP_WH_Tax_T TEMP

1837: AND TEMP.Creation_Date <= TRUNC(AIP_WH.Creation_Date)
1838: THEN TEMP.WH_Tax_Amount ELSE 0 END),0) WH_Tax_Amount,
1839: AIP_WH.Invoice_Payment_ID
1840: FROM AP_Invoice_Payments_All AIP_WH,
1841: FII_AP_WH_Tax_T TEMP
1842: WHERE AIP_WH.Invoice_ID BETWEEN g_start_range and g_end_range
1843: AND AIP_WH.Invoice_ID = TEMP.Invoice_ID (+)
1844: AND AIP_WH.Payment_Num = TEMP.Payment_Num (+)
1845: GROUP BY AIP_WH.Invoice_ID,

Line 2105: FII_AP_WH_Tax_T TEMP

2101: AND TEMP.Creation_Date <= TRUNC(AIP_WH.Creation_Date)
2102: THEN TEMP.WH_Tax_Amount ELSE 0 END),0) WH_Tax_Amount,
2103: AIP_WH.Invoice_Payment_ID
2104: FROM AP_Invoice_Payments_All AIP_WH,
2105: FII_AP_WH_Tax_T TEMP
2106: WHERE AIP_WH.Invoice_ID BETWEEN g_start_range and g_end_range
2107: AND AIP_WH.Invoice_ID = TEMP.Invoice_ID (+)
2108: AND AIP_WH.Payment_Num = TEMP.Payment_Num (+)
2109: GROUP BY AIP_WH.Invoice_ID,

Line 3267: FII_AP_WH_Tax_T AWTS

3263: APS1.Payment_Num,
3264: APS1.Creation_Date,
3265: APS1.Prepay_Amount,
3266: APS1.Check_ID) APS2,
3267: FII_AP_WH_Tax_T AWTS
3268: WHERE APS2.Invoice_ID = AWTS.Invoice_ID (+)
3269: AND APS2.Payment_Num = AWTS.Payment_Num (+)
3270: Group By APS2.Invoice_ID,
3271: APS2.Payment_Num,

Line 3553: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

3549: FROM FII_AP_Invoice_B AI,
3550: FII_AP_PS_Rates_Temp RATES,
3551: FII_AP_Func_Rates_Temp FRATES,
3552: AP_Payment_Schedules_All PS,
3553: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3554: TEM.Payment_Num,
3555: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
3556: FROM FII_AP_WH_Tax_T TEM
3557: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 3556: FROM FII_AP_WH_Tax_T TEM

3552: AP_Payment_Schedules_All PS,
3553: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3554: TEM.Payment_Num,
3555: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
3556: FROM FII_AP_WH_Tax_T TEM
3557: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
3558: AND TEM.Invoice_Type <> 'PREPAYMENT'
3559: AND TRUNC(TEM.Discount_Date) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
3560: AND TEM.Creation_Date < TRUNC(TEM.Discount_Date) + 1

Line 3816: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

3812: FROM FII_AP_Invoice_B AI,
3813: FII_AP_PS_Rates_Temp RATES,
3814: FII_AP_Func_Rates_Temp FRATES,
3815: AP_Payment_Schedules_All PS,
3816: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3817: TEM.Payment_Num,
3818: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
3819: FROM FII_AP_WH_Tax_T TEM
3820: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 3819: FROM FII_AP_WH_Tax_T TEM

3815: AP_Payment_Schedules_All PS,
3816: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3817: TEM.Payment_Num,
3818: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
3819: FROM FII_AP_WH_Tax_T TEM
3820: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
3821: AND TEM.Invoice_Type <> 'PREPAYMENT'
3822: AND TEM.Second_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
3823: AND TEM.Creation_Date < TEM.Second_Discount_Date + 1

Line 4080: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

4076: FROM FII_AP_Invoice_B AI,
4077: FII_AP_PS_Rates_Temp RATES,
4078: FII_AP_Func_Rates_Temp FRATES,
4079: AP_Payment_Schedules_All PS,
4080: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4081: TEM.Payment_Num,
4082: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4083: FROM FII_AP_WH_Tax_T TEM
4084: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 4083: FROM FII_AP_WH_Tax_T TEM

4079: AP_Payment_Schedules_All PS,
4080: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4081: TEM.Payment_Num,
4082: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4083: FROM FII_AP_WH_Tax_T TEM
4084: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
4085: AND TEM.Invoice_Type <> 'PREPAYMENT'
4086: AND TEM.Third_Discount_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
4087: AND TEM.Creation_Date < TEM.Third_Discount_Date + 1

Line 4413: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID Invoice_ID,

4409: FROM FII_AP_Invoice_B AI,
4410: FII_AP_PS_Rates_Temp RATES,
4411: FII_AP_Func_Rates_Temp FRATES,
4412: AP_Payment_Schedules_All PS,
4413: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID Invoice_ID,
4414: TEM.Payment_Num Payment_Num,
4415: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4416: FROM FII_AP_WH_TAX_T TEM
4417: WHERE TEM.Invoice_ID BETWEEN g_start_range and g_end_range

Line 4416: FROM FII_AP_WH_TAX_T TEM

4412: AP_Payment_Schedules_All PS,
4413: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID Invoice_ID,
4414: TEM.Payment_Num Payment_Num,
4415: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4416: FROM FII_AP_WH_TAX_T TEM
4417: WHERE TEM.Invoice_ID BETWEEN g_start_range and g_end_range
4418: AND TEM.Invoice_Type <> 'PREPAYMENT'
4419: AND TEM.Due_Date + 1 BETWEEN g_start_date AND LEAST(g_end_date, g_sysdate)
4420: AND TEM.Due_Date >= TEM.Entered_Date

Line 4718: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

4714: FROM FII_AP_Invoice_B AI,
4715: FII_AP_PS_Rates_Temp RATES,
4716: FII_AP_Func_Rates_Temp FRATES,
4717: AP_Payment_Schedules_All PS,
4718: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4719: TEM.Payment_Num,
4720: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4721: FROM FII_AP_WH_Tax_T TEM
4722: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 4721: FROM FII_AP_WH_Tax_T TEM

4717: AP_Payment_Schedules_All PS,
4718: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4719: TEM.Payment_Num,
4720: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4721: FROM FII_AP_WH_Tax_T TEM
4722: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
4723: AND TEM.Invoice_Type <> 'PREPAYMENT'
4724: AND (TEM.Due_Date - g_due_bucket2) BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
4725: AND TEM.Creation_Date < (TEM.Due_Date - g_due_bucket2)

Line 4993: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

4989: FROM FII_AP_Invoice_B AI,
4990: FII_AP_PS_Rates_Temp RATES,
4991: FII_AP_Func_Rates_Temp FRATES,
4992: AP_Payment_Schedules_All PS,
4993: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4994: TEM.Payment_Num,
4995: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4996: FROM FII_AP_WH_Tax_T TEM
4997: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 4996: FROM FII_AP_WH_Tax_T TEM

4992: AP_Payment_Schedules_All PS,
4993: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4994: TEM.Payment_Num,
4995: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
4996: FROM FII_AP_WH_Tax_T TEM
4997: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
4998: AND TEM.Invoice_Type <> 'PREPAYMENT'
4999: AND (TEM.Due_Date - g_due_bucket3) BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5000: AND TEM.Creation_Date < (TEM.Due_Date - g_due_bucket3)

Line 5295: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

5291: FROM FII_AP_Invoice_B AI,
5292: FII_AP_PS_Rates_Temp RATES,
5293: FII_AP_Func_Rates_Temp FRATES,
5294: AP_Payment_Schedules_All PS,
5295: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5296: TEM.Payment_Num,
5297: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
5298: FROM FII_AP_WH_Tax_T TEM
5299: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 5298: FROM FII_AP_WH_Tax_T TEM

5294: AP_Payment_Schedules_All PS,
5295: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5296: TEM.Payment_Num,
5297: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
5298: FROM FII_AP_WH_Tax_T TEM
5299: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
5300: AND TEM.Invoice_Type <> 'PREPAYMENT'
5301: AND (TEM.Due_Date + g_past_bucket3) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5302: AND TEM.Creation_Date < (TEM.Due_Date + g_past_bucket3) + 1

Line 5568: (SELECT /+ index(TEM,FII_AP_WH_TAX_T_N1) / TEM.Invoice_ID,

5564: FROM FII_AP_Invoice_B AI,
5565: FII_AP_PS_Rates_Temp RATES,
5566: FII_AP_Func_Rates_Temp FRATES,
5567: AP_Payment_Schedules_All PS,
5568: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5569: TEM.Payment_Num,
5570: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
5571: FROM FII_AP_WH_Tax_T TEM
5572: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range

Line 5571: FROM FII_AP_WH_Tax_T TEM

5567: AP_Payment_Schedules_All PS,
5568: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5569: TEM.Payment_Num,
5570: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount
5571: FROM FII_AP_WH_Tax_T TEM
5572: WHERE TEM.Invoice_id BETWEEN g_start_range and g_end_range
5573: AND TEM.Invoice_Type <> 'PREPAYMENT'
5574: AND (TEM.Due_Date + g_past_bucket2) + 1 BETWEEN g_start_date AND LEAST(g_end_date,g_sysdate)
5575: AND TEM.Creation_Date < (TEM.Due_Date + g_past_bucket2) + 1

Line 6401: FROM FII_AP_WH_Tax_T t

6397: GROUP BY AIP.Invoice_id, AIP.Payment_Num) PAY,
6398: (SELECT /*+ parallel(t) */ Invoice_ID,
6399: Payment_Num,
6400: sum(WH_Tax_Amount) WH_Tax_Amount
6401: FROM FII_AP_WH_Tax_T t
6402: GROUP BY Invoice_ID, Payment_Num) TEMP,
6403: (SELECT /*+ parallel(p) */ Invoice_ID,
6404: Payment_Num,
6405: sum(Prepay_Amount) Prepay_Amount,

Line 7034: TRUNCATE_TABLE('FII_AP_WH_TAX_T');

7030: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');
7031: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');
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;

Line 7206: TRUNCATE_TABLE('FII_AP_WH_TAX_T');

7202:
7203:
7204: g_state := 'Truncating temp tables after used to populate base tables';
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: