APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICES_ALL

Line 526: AP_Invoices_All AI,

522: AI.Exchange_Rate Exchange_Rate,
523: NVL(FC.Minimum_Accountable_Unit, 0.01) Functional_MAU,
524: TRUNC(AI.Invoice_Date) Invoice_Date
525: FROM FII_AP_Invoice_IDS ID,
526: AP_Invoices_All AI,
527: AP_System_Parameters_All ASP,
528: FND_Currencies FC
529: WHERE ID.Invoice_ID = AI.Invoice_ID
530: AND ID.Get_Rate_Flag = 'Y'

Line 1072: FROM AP_Invoices_ALL AI

1068:
1069: */
1070: UPDATE FII_AP_Hold_Hist_B HH
1071: SET Supplier_ID = (SELECT AI.Vendor_ID
1072: FROM AP_Invoices_ALL AI
1073: WHERE AI.Invoice_ID = HH.Invoice_ID)
1074: WHERE HH.Invoice_ID IN (SELECT Key_Value1_Num
1075: FROM FII_AP_DBI_LOG_T
1076: WHERE Table_Name = 'AP_INVOICES'

Line 1416: AP_Invoices_All AI,

1412: ID.Invoice_B_Flag Invoice_B_Flag,
1413: ID.Pay_Sched_B_Flag Pay_Sched_B_Flag
1414: BULK COLLECT INTO FII_AP_Inv_MS
1415: FROM FII_AP_Invoice_IDS ID,
1416: AP_Invoices_All AI,
1417: AP_Invoice_Distributions_All AID,
1418: AP_System_Parameters_All ASP,
1419: FND_Currencies FC,
1420: FII_AP_PS_Rates_Temp RATES,

Line 4487: to AP_INVOICES_ALL table here. Only join here between AP_INVOICES_ALL

4483: GROUP BY INVIDS.Invoice_ID;
4484:
4485: /* Commenting this code as per performance bug review
4486: Bug 4943180. Don't find any functional reason, why we should join
4487: to AP_INVOICES_ALL table here. Only join here between AP_INVOICES_ALL
4488: and INVIDS is on invoice_id and that is a outer join. All other
4489: whereclauses doesn't do much in that situation */
4490:
4491:

Line 4493: AP_Invoices_All AI

4489: whereclauses doesn't do much in that situation */
4490:
4491:
4492: /*,
4493: AP_Invoices_All AI
4494: WHERE INVIDS.Invoice_ID = AI.Invoice_ID (+)
4495: AND (AI.Invoice_Type_Lookup_Code IS NULL OR AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT')
4496: AND (AI.Invoice_Amount IS NULL OR AI.Invoice_Amount <> 0 OR (AI.Invoice_Amount = 0 AND AI.Cancelled_Date IS NOT NULL))
4497: AND (AI.Creation_Date IS NULL OR TRUNC(AI.Creation_Date) >= g_start_date)*/