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 FII_AP_INVOICE_IDS

Line 525: FROM FII_AP_Invoice_IDS ID,

521: NVL(AI.Exchange_Rate_Type,'No Rate Type') Exchange_Rate_Type,
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

Line 1415: FROM FII_AP_Invoice_IDS ID,

1411: FRATES.Conversion_Rate * RATES.Sec_Conversion_Rate) To_Sec_Rate,
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,

Line 1467: FROM FII_AP_Invoice_IDS ID,

1463: NVL(PS.Third_Disc_Amt_Available, 0) Third_Disc_Amt_Available,
1464: PS.Created_By Created_By,
1465: NULL Fully_Paid_Date
1466: BULK COLLECT INTO FII_AP_Pay_Sched_MS
1467: FROM FII_AP_Invoice_IDS ID,
1468: AP_Payment_Schedules_All PS
1469: WHERE ID.Invoice_ID = PS.Invoice_ID
1470: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')
1471: ORDER BY PS.Invoice_ID, PS.Payment_Num;

Line 1494: FROM FII_AP_Invoice_IDS ID,

1490: AC.Check_Date Check_Date,
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

Line 1524: FROM FII_AP_Invoice_IDS ID,

1520: SUM(AID.Amount) Amount,
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

Line 1568: FROM FII_AP_Invoice_IDS ID,

1564: AID.Invoice_ID,
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

Line 1639: FROM FII_AP_Invoice_IDS ID,

1635: PSUM.Fully_Paid_Date, PSUM.Check_ID, PSUM.Payment_Method, PSUM.Last_Update_Date,
1636: PSUM.Last_Updated_By, PSUM.Creation_Date, PSUM.Created_By, PSUM.Last_Update_Login,
1637: PSUM.Check_Date, PSUM.Inv_Pymt_Flag, PSUM.Unique_ID
1638: BULK COLLECT INTO FII_AP_Pay_Sched_B_MS
1639: FROM FII_AP_Invoice_IDS ID,
1640: FII_AP_Pay_Sched_B PSUM
1641: WHERE ID.Invoice_ID = PSUM.Invoice_ID
1642: AND (ID.Pay_Sched_B_Flag = 'Y' OR ID.Delete_Inv_Flag='Y')
1643: ORDER BY PSUM.Invoice_ID,

Line 1682: FROM FII_AP_Invoice_IDS ID,

1678: AI.Exchange_Date, AI.Exchange_Rate, AI.Exchange_Rate_Type, AI.Payment_Status_Flag,
1679: AI.Payment_Cross_Rate, AI.Fully_Paid_Amount, AI.Fully_Paid_Amount_B,
1680: AI.Prim_Fully_Paid_Amount, AI.Sec_Fully_Paid_Amount
1681: BULK COLLECT INTO FII_AP_Invoice_B_MS
1682: FROM FII_AP_Invoice_IDS ID,
1683: FII_AP_Invoice_B AI
1684: WHERE ID.Invoice_ID = AI.Invoice_ID
1685: AND ID.Invoice_B_Flag = 'Y'
1686: ORDER BY AI.Invoice_ID;

Line 2168: FROM FII_AP_Invoice_IDS

2164: end if;
2165:
2166: DELETE /*+ index(A, FII_AP_AGING_BKTS_B_N1) */ FROM FII_AP_Aging_Bkts_B A
2167: WHERE Invoice_ID IN (SELECT Invoice_ID
2168: FROM FII_AP_Invoice_IDS
2169: WHERE Pay_Sched_B_Flag = 'Y');
2170:
2171: g_state := 'Deleting existing records from FII_AP_DUE_COUNTS_B';
2172: if g_debug_flag = 'Y' then

Line 2179: FROM FII_AP_Invoice_IDS

2175: end if;
2176:
2177: DELETE /*+ index(A, FII_AP_DUE_COUNTS_B_N1) */ FROM FII_AP_Due_Counts_B A
2178: WHERE Invoice_ID IN (SELECT Invoice_ID
2179: FROM FII_AP_Invoice_IDS
2180: WHERE Pay_Sched_B_Flag = 'Y');
2181:
2182:
2183: g_state := 'Populating g_seq_id from fii_ap_pay_sched_b';

Line 4355: TRUNCATE_TABLE('FII_AP_INVOICE_IDS');

4351: -- TRUNCATE_TABLE('FII_AP_WH_TAX_T');
4352: -- TRUNCATE_TABLE('FII_AP_PREPAY_T');
4353:
4354: TRUNCATE_TABLE('FII_AP_DBI_LOG_T');
4355: TRUNCATE_TABLE('FII_AP_INVOICE_IDS');
4356:
4357: INSERT into FII_AP_DBI_LOG_T(Key_Value1_Num,
4358: Key_Value2_Num,
4359: Table_Name,

Line 4395: g_state := 'Inserting records into the FII_AP_INVOICE_IDS table';

4391:
4392: COMMIT;
4393:
4394:
4395: g_state := 'Inserting records into the FII_AP_INVOICE_IDS table';
4396: if g_debug_flag = 'Y' then
4397: FII_UTIL.put_line('');
4398: FII_UTIL.put_line(g_state);
4399: FII_UTIL.start_timer;

Line 4403: INSERT INTO FII_AP_Invoice_IDS

4399: FII_UTIL.start_timer;
4400: FII_UTIL.put_line('');
4401: end if;
4402:
4403: INSERT INTO FII_AP_Invoice_IDS
4404: (Invoice_ID,
4405: Invoice_B_Flag,
4406: Pay_Sched_B_Flag,
4407: Get_Rate_Flag,

Line 4501: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_INVOICE_IDS');

4497: AND (AI.Creation_Date IS NULL OR TRUNC(AI.Creation_Date) >= g_start_date)*/
4498:
4499:
4500:
4501: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_INVOICE_IDS');
4502:
4503:
4504: if g_debug_flag = 'Y' then
4505: FII_UTIL.put_line('-------------------------------------------------');