APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1495: AP_Invoice_Payments_ALL AIP,

1491: DECODE(IBY_SYS_PROF_B.Processing_Type,NULL,DECODE(AC.Payment_Method_Lookup_Code, 'EFT', 'E', 'WIRE', 'E', 'M')
1492: ,DECODE(IBY_SYS_PROF_B.Processing_Type, 'ELECTRONIC', 'E', 'M')) Processing_Type
1493: BULK COLLECT INTO FII_AP_Inv_Pay_MS
1494: FROM FII_AP_Invoice_IDS ID,
1495: AP_Invoice_Payments_ALL AIP,
1496: AP_Checks_ALL AC,
1497: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B, --IBY CHANGE
1498: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1499: WHERE ID.Invoice_ID = AIP.Invoice_ID

Line 1582: AP_Invoice_Payments_All AIP

1578: AND NVL(AID.Reversal_Flag,'N') = 'N'
1579: AND (AIL.Invoice_Includes_Prepay_Flag IS NULL OR AIL.Invoice_Includes_Prepay_Flag = 'N')
1580: AND AID.Prepay_Distribution_ID = TEMP.Invoice_Distribution_ID
1581: GROUP BY AID.Invoice_ID, TRUNC(AID.Creation_Date), TEMP.Invoice_ID) TEMP1,
1582: AP_Invoice_Payments_All AIP
1583: WHERE TEMP1.Prepay_Invoice_ID = AIP.Invoice_ID
1584: GROUP BY TEMP1.Invoice_ID, TEMP1.Creation_Date, TEMP1.Prepay_Invoice_ID, TEMP1.Amount) TEMP2,
1585: AP_Checks_All AC,
1586: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE

Line 4458: FROM FII_AP_DBI_LOG_T LOG, AP_Invoice_Payments_All AIP

4454: UNION
4455: SELECT AIP.Invoice_ID Invoice_ID,
4456: Table_Name,
4457: Operation_Flag
4458: FROM FII_AP_DBI_LOG_T LOG, AP_Invoice_Payments_All AIP
4459: WHERE Table_Name = 'AP_INVOICE_PAYMENTS'
4460: AND LOG.Key_Value1_Num = AIP.Invoice_Payment_ID
4461: UNION
4462: SELECT PS.Invoice_ID Invoice_ID,