APPS.FII_AP_INV_SUM_INIT dependencies on AP_INVOICE_LINES_ALL

Line 554: AP_Invoice_Lines_All AIL,

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
558: AND AID.Invoice_ID = AIL.Invoice_ID

Line 648: AP_Invoice_Lines_All AIL,

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
652: FROM AP_Invoice_Payments_All AIP1

Line 1403: AP_Invoice_Lines_All AIL

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 (+)
1407: AND AI.Org_ID = ASP.Org_ID

Line 2806: AP_Invoice_Lines_All AIL,

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,
2810: FND_Currencies FC