[Home] [Help]
549: SUM(AID.Amount)/AI.Invoice_Amount
550: / FC.Minimum_Accountable_Unit) * FC.Minimum_Accountable_Unit))
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
643: SUM(SUM(-1*AID.Amount * AI.Payment_Cross_Rate)) OVER (PARTITION BY AID.Invoice_ID
644: ORDER BY AID.Invoice_ID, TRUNC(AID.Creation_Date)
645: ROWS UNBOUNDED PRECEDING) AS Last,
646: AIP.Check_ID Check_ID
647: FROM AP_Invoice_Distributions_All AID,
648: AP_Invoice_Lines_All AIL,
649: AP_Invoice_Distributions_All TEMP,
650: (SELECT /*+ parallel(AIP1) */ Invoice_ID Invoice_ID,
651: MIN(Check_ID) Check_ID
645: ROWS UNBOUNDED PRECEDING) AS Last,
646: AIP.Check_ID Check_ID
647: FROM AP_Invoice_Distributions_All AID,
648: AP_Invoice_Lines_All AIL,
649: AP_Invoice_Distributions_All TEMP,
650: (SELECT /*+ parallel(AIP1) */ Invoice_ID Invoice_ID,
651: MIN(Check_ID) Check_ID
652: FROM AP_Invoice_Payments_All AIP1
653: GROUP BY Invoice_ID) AIP,
1398: sysdate Last_Update_Date,
1399: g_fii_login_id Last_Update_Login
1400: FROM AP_System_Parameters_All ASP,
1401: AP_Invoices_All AI,
1402: AP_Invoice_Distributions_All AID,
1403: AP_Invoice_Lines_All AIL
1404: WHERE AI.Invoice_ID = AIL.Invoice_ID (+)
1405: AND AIL.Invoice_ID = AID.Invoice_ID (+)
1406: AND AIL.Line_Number = AID.Invoice_Line_Number (+)
2801: g_fii_user_id Last_Updated_By,
2802: sysdate Last_Update_Date,
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,