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 AP_PAYMENT_SCHEDULES_ALL

Line 555: AP_Payment_Schedules_All PS,

551: WH_Tax_Amount
552: FROM FII_AP_Invoice_B AI,
553: AP_Invoice_Distributions_All AID,
554: AP_Invoice_Lines_All AIL,
555: AP_Payment_Schedules_All PS,
556: FND_Currencies FC
557: WHERE AI.Invoice_ID = AID.Invoice_ID
558: AND AID.Invoice_ID = AIL.Invoice_ID
559: AND AID.Invoice_Line_Number = AIL.Line_Number

Line 692: AP_PAYMENT_SCHEDULES_ALL PS,

688: TRUNC(PS.Third_Discount_Date) Third_Discount_Date,
689: TRUNC(AI.Entered_Date) Entered_Date,
690: PS.Gross_Amount - PS.Amount_Remaining - NVL(PAY.Payment_Amount,0) - NVL(TEMP.WH_Tax_Amount, 0) PP_Amount
691: FROM FII_AP_INVOICE_B AI,
692: AP_PAYMENT_SCHEDULES_ALL PS,
693: (SELECT /*+ parallel(AI) parallel(AIP) parallel(PS) */
694: AIP.Invoice_ID Invoice_ID,
695: AIP.Payment_Num Payment_Num,
696: SUM(AIP.Amount + NVL(AIP.Discount_Taken, 0)) Payment_Amount

Line 699: AP_Payment_Schedules_All PS

695: AIP.Payment_Num Payment_Num,
696: SUM(AIP.Amount + NVL(AIP.Discount_Taken, 0)) Payment_Amount
697: FROM AP_Invoice_Payments_All AIP,
698: FII_AP_Invoice_B AI,
699: AP_Payment_Schedules_All PS
700: WHERE PS.Invoice_ID = AI.Invoice_ID
701: AND AIP.Invoice_ID = AI.Invoice_ID
702: AND AI.Invoice_Type NOT IN ('PREPAYMENT')
703: AND AI.Cancel_Date IS NULL

Line 797: AP_Payment_Schedules_All PS

793: TRUNC(AIP.Creation_Date) Invp_Creation_Date
794: FROM FII_AP_INVOICE_B AI,
795: AP_Checks_All AC,
796: AP_Invoice_Payments_All AIP,
797: AP_Payment_Schedules_All PS
798: WHERE AI.Invoice_ID = PS.Invoice_ID
799: AND PS.Invoice_ID = AIP.Invoice_ID
800: AND PS.Payment_Num = AIP.Payment_Num
801: AND AC.Check_ID = AIP.Check_ID

Line 1437: FROM AP_Payment_Schedules_all PS

1433: (SELECT /*+ no_merge parallel(PS) */
1434: PS.Invoice_ID,
1435: SUM(NVL(PS.Discount_Amount_Available,0)) Discount_Amount_Available,
1436: TRUNC(MIN(PS.Due_Date)) Due_Date
1437: FROM AP_Payment_Schedules_all PS
1438: GROUP BY PS.Invoice_ID ) PS,
1439: (SELECT /*+ no_merge parallel(AIP) */
1440: AIP.Invoice_id Invoice_ID,
1441: TRUNC(MAX(AIP.Creation_Date)) Fully_Paid_Date,

Line 1816: AP_Payment_Schedules_All PS,

1812: DECODE(IBY_SYS_PROF_B.Processing_Type,NULL,DECODE(AC.Payment_Method_Lookup_Code, 'EFT', 'E', 'WIRE', 'E', 'M')
1813: ,DECODE(IBY_SYS_PROF_B.Processing_Type, 'ELECTRONIC', 'E', 'M')) PAYMENT_METHOD,
1814: AIP.Invoice_Payment_ID
1815: FROM FII_AP_Invoice_B AI,
1816: AP_Payment_Schedules_All PS,
1817: (SELECT /*+ leading(aip_pp) use_nl(aip_pp,pp) */ AIP_PP.Invoice_ID,
1818: AIP_PP.Payment_Num,
1819: AIP_PP.Creation_Date,
1820: AIP_PP.Created_By,

Line 2071: AP_Payment_Schedules_All PS

2067: SUM(Discount_Available) Discount_Available,
2068: SUM(Discount_Lost) Discount_Lost,
2069: SUM(Discount_Taken) Discount_Taken
2070: FROM FII_AP_Pay_Sched_B PSUM,
2071: AP_Payment_Schedules_All PS
2072: WHERE PS.Invoice_ID BETWEEN g_start_range and g_end_range
2073: AND PS.Invoice_ID = PSUM.Invoice_ID (+)
2074: AND PS.Payment_Num = PSUM.Payment_Num (+)
2075: AND PSUM.Period_Type_ID (+) = 1

Line 2078: AP_Payment_Schedules_All PS,

2074: AND PS.Payment_Num = PSUM.Payment_Num (+)
2075: AND PSUM.Period_Type_ID (+) = 1
2076: GROUP BY PS.Invoice_ID,
2077: PS.Payment_Num) DISC,
2078: AP_Payment_Schedules_All PS,
2079: FII_AP_Invoice_B AI,
2080: (SELECT /*+ merge(aip_pp) use_nl(aip_pp, pp) */
2081: AIP_PP.Invoice_ID,
2082: AIP_PP.Payment_Num,

Line 2807: AP_Payment_Schedules_All PS,

2803: g_fii_login_id Last_Update_Login
2804: FROM FII_AP_Invoice_B AI,
2805: AP_Invoice_Distributions_All AID,
2806: AP_Invoice_Lines_All AIL,
2807: AP_Payment_Schedules_All PS,
2808: FII_AP_PS_Rates_Temp RATES,
2809: FII_AP_Func_Rates_Temp FRATES,
2810: FND_Currencies FC
2811: WHERE PS.Invoice_ID = AI.Invoice_ID

Line 3230: AP_Payment_Schedules_All PS,

3226: g_fii_login_id Last_Update_Login,
3227: 'N' Inv_Pymt_Flag,
3228: AC.Check_ID Unique_ID
3229: FROM FII_AP_INVOICE_B AI,
3230: AP_Payment_Schedules_All PS,
3231: (SELECT /*+ use_nl(aps3,pp) */APS3.Invoice_ID,
3232: APS3.Payment_Num,
3233: APS3.Creation_Date,
3234: APS3.Prepay_Amount,

Line 3552: AP_Payment_Schedules_All PS,

3548: 1 Unique_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

Line 3815: AP_Payment_Schedules_All PS,

3811: 2 Unique_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

Line 4079: AP_Payment_Schedules_All PS,

4075: 3 Unique_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

Line 4412: AP_Payment_Schedules_All PS,

4408: g_fii_login_id Last_Update_Login
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

Line 4717: AP_Payment_Schedules_All PS,

4713: g_fii_login_id Last_Update_Login
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

Line 4992: AP_Payment_Schedules_All PS,

4988: g_fii_login_id Last_Update_Login
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

Line 5294: AP_Payment_Schedules_All PS,

5290: g_fii_login_id Last_Update_Login
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

Line 5567: AP_Payment_Schedules_All PS,

5563: g_fii_login_id Last_Update_Login
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

Line 5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';

5676: SELECT fii_ap_pay_sched_b_s.nextval
5677: INTO g_seq_id
5678: FROM dual;
5679:
5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';
5681: if g_debug_flag = 'Y' then
5682: FII_UTIL.put_line(g_state);
5683: end if;
5684:

Line 5958: FROM AP_Payment_Schedules_All PS,

5954: AND (AI.Entered_Date - TRUNC(PS.Due_Date)) > 0
5955: THEN PS.Gross_Amount
5956: ELSE 0
5957: END Past_Due_Bucket3
5958: FROM AP_Payment_Schedules_All PS,
5959: FII_AP_Invoice_B AI
5960: WHERE PS.Invoice_ID = AI.Invoice_ID
5961: AND AI.Invoice_ID BETWEEN g_start_range and g_end_range
5962: AND AI.Invoice_Type NOT IN ('PREPAYMENT')

Line 6390: FROM AP_Payment_Schedules_All PS,

6386: AND PP.Payment_Date is not null
6387: THEN greatest(PAY.Payment_Date, PP.Payment_Date)
6388: ELSE nvl(PAY.Payment_Date, PP.Payment_Date) END
6389: ELSE null END Fully_Paid_Date
6390: FROM AP_Payment_Schedules_All PS,
6391: FII_AP_INVOICE_B AI,
6392: (SELECT /*+ parallel(aip) */ AIP.Invoice_ID,
6393: AIP.Payment_Num,
6394: sum(AIP.Amount + nvl(AIP.Discount_Taken, 0)) Payment_Amount,

Line 7137: -- updating the AP_PAYMENT_SCHEDULES_ALL table

7133: MONITOR_WORKER;
7134:
7135: -------------------------------------------------------------------
7136: -- Analyze Payment schedule table after all workers have completed
7137: -- updating the AP_PAYMENT_SCHEDULES_ALL table
7138: -------------------------------------------------------------------
7139: FND_STATS.GATHER_TABLE_STATS(g_ap_schema,'AP_PAYMENT_SCHEDULES_ALL');
7140: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
7141:

Line 7139: FND_STATS.GATHER_TABLE_STATS(g_ap_schema,'AP_PAYMENT_SCHEDULES_ALL');

7135: -------------------------------------------------------------------
7136: -- Analyze Payment schedule table after all workers have completed
7137: -- updating the AP_PAYMENT_SCHEDULES_ALL table
7138: -------------------------------------------------------------------
7139: FND_STATS.GATHER_TABLE_STATS(g_ap_schema,'AP_PAYMENT_SCHEDULES_ALL');
7140: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
7141:
7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');
7143: