eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1417: AP_Invoice_Distributions_All AID,

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,
1421: FII_AP_Func_Rates_Temp FRATES

Line 1525: AP_Invoice_Distributions_ALL AID,

1521: TRUNC(AID.Creation_Date) Creation_Date,
1522: MAX(AID.Invoice_Distribution_ID) Invoice_Distribution_ID --Any invoice distribution id is ok. Just used to make the record unique.
1523: BULK COLLECT INTO FII_AP_WH_Tax_MS
1524: FROM FII_AP_Invoice_IDS ID,
1525: AP_Invoice_Distributions_ALL AID,
1526: AP_Invoice_Lines_ALL AIL
1527: WHERE ID.Invoice_ID = AID.Invoice_ID
1528: AND AID.Invoice_ID = AIL.Invoice_ID
1529: AND AID.Invoice_Line_Number = AIL.Line_Number

Line 1569: AP_Invoice_Distributions_All AID,

1565: TRUNC(AID.Creation_Date) Creation_Date,
1566: TEMP.Invoice_ID Prepay_Invoice_ID,
1567: SUM(AID.Amount) Amount
1568: FROM FII_AP_Invoice_IDS ID,
1569: AP_Invoice_Distributions_All AID,
1570: AP_Invoice_Lines_ALL AIL,
1571: AP_Invoice_Distributions_ALL TEMP
1572: WHERE ID.Invoice_ID = AID.Invoice_ID
1573: AND AID.Invoice_ID = AIL.Invoice_ID

Line 1571: AP_Invoice_Distributions_ALL TEMP

1567: SUM(AID.Amount) Amount
1568: FROM FII_AP_Invoice_IDS ID,
1569: AP_Invoice_Distributions_All AID,
1570: AP_Invoice_Lines_ALL AIL,
1571: AP_Invoice_Distributions_ALL TEMP
1572: WHERE ID.Invoice_ID = AID.Invoice_ID
1573: AND AID.Invoice_ID = AIL.Invoice_ID
1574: AND AID.Invoice_Line_Number = AIL.Line_Number
1575: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')

Line 4450: FROM FII_AP_DBI_LOG_T LOG, AP_Invoice_Distributions_All AID

4446: UNION
4447: SELECT LOG.Key_Value1_Num Invoice_ID,
4448: LOG.Table_Name Table_Name,
4449: LOG.Operation_Flag Operation_Flag
4450: FROM FII_AP_DBI_LOG_T LOG, AP_Invoice_Distributions_All AID
4451: WHERE LOG.Table_Name = 'AP_INVOICE_DISTRIBUTIONS'
4452: AND LOG.Key_Value2_Num = AID.Invoice_Distribution_ID
4453: AND AID.Line_Type_Lookup_Code IN ('PREPAY', 'AWT', 'NONREC_TAX', 'REC_TAX')
4454: UNION