APPS.FII_AP_INV_SUM_INIT dependencies on AP_INVOICES_ALL

Line 654: AP_Invoices_All AI,

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,
654: AP_Invoices_All AI,
655: FND_Currencies FC
656: WHERE AID.Invoice_ID = AI.Invoice_ID
657: AND AID.Invoice_ID = AIL.Invoice_ID
658: AND AID.Invoice_Line_Number = AIL.Line_Number

Line 999: FROM AP_Invoices_All AI,

995: FROM (
996: SELECT /*+ parallel(ASP) parallel(AI) use_hash(AI) */
997: Distinct ASP.Base_Currency_code Curr_Code,
998: TRUNC(AI.Invoice_Date) Trx_Date
999: FROM AP_Invoices_All AI,
1000: AP_System_Parameters_All ASP
1001: WHERE AI.Org_ID = ASP.Org_ID
1002: AND AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT'
1003: AND AI.Invoice_Amount <> 0

Line 1050: FROM AP_Invoices_All AI,

1046: NVL(AI.Exchange_Rate_Type,'No Rate Type') Exchange_Rate_Type,
1047: DECODE(AI.Exchange_Rate_Type, 'User', AI.Exchange_Rate, 1)
1048: Exchange_Rate,
1049: NVL(FC.Minimum_Accountable_Unit, 0.01) Functional_MAU
1050: FROM AP_Invoices_All AI,
1051: AP_System_Parameters_All ASP,
1052: FND_Currencies FC
1053: WHERE AI.Org_ID = ASP.Org_ID
1054: AND AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT'

Line 1220: g_state := 'Populating FII_AP_INVOICE_B FROM AP_INVOICES_ALL table';

1216: and re-populate this table */
1217: TRUNCATE_TABLE('MLOG$_FII_AP_INVOICE_B');
1218: TRUNCATE_TABLE('FII_AP_INVOICE_B');
1219:
1220: g_state := 'Populating FII_AP_INVOICE_B FROM AP_INVOICES_ALL table';
1221: if g_debug_flag = 'Y' then
1222: FII_UTIL.put_line(g_state);
1223: FII_UTIL.start_timer;
1224: FII_UTIL.put_line('');

Line 1401: AP_Invoices_All AI,

1397: g_fii_user_id Last_Updated_By,
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 (+)