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_DBI_LOG

Line 657: FROM FII_AP_DBI_LOG_T

653: end if;
654:
655: DELETE FROM FII_AP_AGING_BKTS_B
656: WHERE Invoice_ID IN (SELECT Key_Value1_Num
657: FROM FII_AP_DBI_LOG_T
658: WHERE Table_Name = 'AP_INVOICES'
659: AND Operation_Flag = 'D');
660:
661: if g_debug_flag = 'Y' then

Line 675: FROM FII_AP_DBI_LOG_T

671: end if;
672:
673: DELETE FROM FII_AP_DUE_COUNTS_B
674: WHERE Invoice_ID IN (SELECT Key_Value1_Num
675: FROM FII_AP_DBI_LOG_T
676: WHERE Table_Name = 'AP_INVOICES'
677: AND Operation_Flag = 'D');
678:
679: if g_debug_flag = 'Y' then

Line 693: FROM FII_AP_DBI_LOG_T

689: end if;
690:
691: DELETE FROM FII_AP_INV_HOLDS_B
692: WHERE Invoice_ID IN (SELECT Key_Value1_Num
693: FROM FII_AP_DBI_LOG_T
694: WHERE Table_Name = 'AP_INVOICES'
695: AND Operation_Flag = 'D');
696:
697: if g_debug_flag = 'Y' then

Line 711: FROM FII_AP_DBI_LOG_T

707: end if;
708:
709: DELETE FROM FII_AP_HOLD_HIST_B
710: WHERE Invoice_ID IN (SELECT Key_Value1_Num
711: FROM FII_AP_DBI_LOG_T
712: WHERE Table_Name = 'AP_INVOICES'
713: AND Operation_Flag = 'D');
714:
715: if g_debug_flag = 'Y' then

Line 758: FROM FII_AP_DBI_LOG_T T

754: end if;
755:
756: DELETE FROM FII_AP_INV_HOLDS_B
757: WHERE Invoice_ID IN (SELECT /*+ cardinality(T,100) */ Key_Value1_Num
758: FROM FII_AP_DBI_LOG_T T
759: WHERE Table_Name = 'AP_HOLDS');
760:
761: DELETE /*+ index(B) push_subq */ FROM FII_AP_INV_HOLDS_B B
762: WHERE Invoice_ID IN (SELECT /*+ cardinality(Log,1) */ Key_Value1_Num

Line 763: FROM FII_AP_DBI_LOG_T Log, FII_AP_Invoice_B AI

759: WHERE Table_Name = 'AP_HOLDS');
760:
761: DELETE /*+ index(B) push_subq */ FROM FII_AP_INV_HOLDS_B B
762: WHERE Invoice_ID IN (SELECT /*+ cardinality(Log,1) */ Key_Value1_Num
763: FROM FII_AP_DBI_LOG_T Log, FII_AP_Invoice_B AI
764: WHERE Log.Key_Value1_Num = AI.Invoice_ID
765: AND AI.Cancel_Date IS NOT NULL
766: AND Log.Table_Name = 'AP_INVOICES');
767:

Line 828: FROM FII_AP_DBI_LOG_T

824: g_fii_user_id Last_Updated_By,
825: sysdate Last_Update_Date,
826: g_fii_login_id Last_Update_Login
827: FROM (SELECT /*+ no_merge */ distinct Key_Value1_Num
828: FROM FII_AP_DBI_LOG_T
829: WHERE Table_Name = 'AP_HOLDS'
830: AND Operation_Flag IN ('I','U')) T,
831: AP_Holds_All AH,
832: FII_AP_Invoice_B AI

Line 850: FROM FII_AP_DBI_LOG_T

846: SET Supplier_ID = (SELECT AI.Supplier_ID
847: FROM FII_AP_Invoice_B AI
848: WHERE AI.Invoice_ID = HSUM.Invoice_ID)
849: WHERE HSUM.Invoice_ID IN (SELECT Key_Value1_Num
850: FROM FII_AP_DBI_LOG_T
851: WHERE Table_Name = 'AP_INVOICES'
852: AND Operation_Flag = 'U');
853:
854:

Line 897: FROM FII_AP_DBI_LOG_T LOG

893: that the records will not be duplicated in the History table */
894:
895: DELETE FROM FII_AP_Hold_Hist_B
896: WHERE Invoice_ID IN (SELECT LOG.Key_Value1_Num
897: FROM FII_AP_DBI_LOG_T LOG
898: WHERE Table_Name = 'AP_HOLDS');
899:
900: DELETE /*+ index(B) push_subq */ FROM FII_AP_Hold_Hist_B
901: WHERE Invoice_ID IN (SELECT /*+ cardinality(LOG,1) */ Key_Value1_Num

Line 902: FROM FII_AP_DBI_LOG_T LOG, FII_AP_Invoice_B AI

898: WHERE Table_Name = 'AP_HOLDS');
899:
900: DELETE /*+ index(B) push_subq */ FROM FII_AP_Hold_Hist_B
901: WHERE Invoice_ID IN (SELECT /*+ cardinality(LOG,1) */ Key_Value1_Num
902: FROM FII_AP_DBI_LOG_T LOG, FII_AP_Invoice_B AI
903: WHERE LOG.Key_Value1_Num = AI.Invoice_ID
904: AND AI.Cancel_Date IS NOT NULL
905: AND LOG.Table_Name = 'AP_INVOICES');
906:

Line 962: FROM FII_AP_DBI_LOG_T lt

958: AI.Invoice_ID,
959: TRUNC(DECODE(RT.Rec_Type, 'H', AH.Hold_Date, AH.Last_Update_Date)) H_R_Date,
960: RT.Rec_Type
961: FROM (SELECT /*+ no_merge index(lt) */ distinct Key_Value1_Num
962: FROM FII_AP_DBI_LOG_T lt
963: WHERE Table_Name = 'AP_HOLDS'
964: AND Operation_Flag IN ('I','U')) LOG,
965: AP_HOLDS_ALL AH,
966: FII_AP_INVOICE_B AI,

Line 1075: FROM FII_AP_DBI_LOG_T

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'
1077: AND Operation_Flag = 'U');
1078:
1079:

Line 4169: FROM FII_AP_DBI_LOG_T

4165: SET Supplier_ID = (SELECT AI.Supplier_ID
4166: FROM FII_AP_Invoice_B AI
4167: WHERE AI.Invoice_ID = AB.Invoice_ID)
4168: WHERE AB.Invoice_ID IN (SELECT Key_Value1_Num
4169: FROM FII_AP_DBI_LOG_T
4170: WHERE Table_Name = 'AP_INVOICES'
4171: AND Operation_Flag = 'U');
4172:
4173: g_state := 'Updating Supplier_ID in FII_AP_DUE_COUNTS_B';

Line 4179: FROM FII_AP_DBI_LOG_T

4175: SET Supplier_ID = (SELECT AI.Supplier_ID
4176: FROM FII_AP_Invoice_B AI
4177: WHERE AI.Invoice_ID = DC.Invoice_ID)
4178: WHERE DC.Invoice_ID IN (SELECT Key_Value1_Num
4179: FROM FII_AP_DBI_LOG_T
4180: WHERE Table_Name = 'AP_INVOICES'
4181: AND Operation_Flag = 'U');
4182:
4183:

Line 4265: --Get timestamps used to maintain ap_dbi_log.

4261: return;
4262: END IF;
4263:
4264: ------------------------------------------------------------
4265: --Get timestamps used to maintain ap_dbi_log.
4266: --g_timestamp1 - current timestamp.
4267: --g_timestamp2 - last Payables Operation/Expenses load.
4268: --g_timestamp3 - last Payables Expenses load, if implemented.
4269: --g_timestamp4 - last Payables Operation load.

Line 4271: g_state := 'Defining timestamps to maintain ap_dbi_log.';

4267: --g_timestamp2 - last Payables Operation/Expenses load.
4268: --g_timestamp3 - last Payables Expenses load, if implemented.
4269: --g_timestamp4 - last Payables Operation load.
4270: -------------------------------------------------------------
4271: g_state := 'Defining timestamps to maintain ap_dbi_log.';
4272: IF g_debug_flag = 'Y' then
4273: FII_UTIL.put_line('');
4274: FII_UTIL.put_line(g_state);
4275: fii_util.put_line('');

Line 4354: TRUNCATE_TABLE('FII_AP_DBI_LOG_T');

4350: -- TRUNCATE_TABLE('FII_AP_PAY_SCHED_ID');
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,

Line 4357: INSERT into FII_AP_DBI_LOG_T(Key_Value1_Num,

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,
4360: Operation_Flag,
4361: Creation_Date,

Line 4379: FROM AP_DBI_LOG

4375: FROM (SELECT Key_Value1 Key_Value1_Num,
4376: Key_Value2 Key_Value2_Num,
4377: Table_Name,
4378: Operation_Flag
4379: FROM AP_DBI_LOG
4380: WHERE Creation_Date >= g_timestamp2
4381: AND Creation_Date < g_timestamp1
4382: UNION
4383: SELECT Key_Value1_ID Key_Value1_Num,

Line 4387: FROM FII_AP_DBI_Log_PS_T)

4383: SELECT Key_Value1_ID Key_Value1_Num,
4384: Key_Value2_ID Key_Value2_Num,
4385: Table_Name,
4386: Operation_Flag
4387: FROM FII_AP_DBI_Log_PS_T)
4388: GROUP BY Key_Value1_Num, Key_Value2_Num, Table_Name, Operation_Flag;
4389:
4390: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_DBI_LOG_T');
4391:

Line 4390: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_DBI_LOG_T');

4386: Operation_Flag
4387: FROM FII_AP_DBI_Log_PS_T)
4388: GROUP BY Key_Value1_Num, Key_Value2_Num, Table_Name, Operation_Flag;
4389:
4390: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_DBI_LOG_T');
4391:
4392: COMMIT;
4393:
4394:

Line 4432: FROM FII_AP_DBI_LOG_T

4428: FROM (SELECT Key_Value1_Num Invoice_ID,
4429: 1 Rank,
4430: Table_Name,
4431: Operation_Flag
4432: FROM FII_AP_DBI_LOG_T
4433: WHERE Table_Name IN ('AP_INVOICES', 'AP_HOLDS', 'AP_PAYMENT_SCHEDULES',
4434: 'AP_INVOICE_DISTRIBUTIONS')
4435: UNION
4436: SELECT Invoice_ID,

Line 4444: FROM FII_AP_DBI_LOG_T

4440: FROM (
4441: SELECT Key_Value1_Num Invoice_ID,
4442: Table_Name,
4443: Operation_Flag
4444: FROM FII_AP_DBI_LOG_T
4445: WHERE Table_Name = 'AP_PAYMENT_SCHEDULES'
4446: UNION
4447: SELECT LOG.Key_Value1_Num Invoice_ID,
4448: LOG.Table_Name Table_Name,

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

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,

Line 4569: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.

4565:
4566: POPULATE_HOLD_HISTORY;
4567: g_retcode := 0;
4568:
4569: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
4570:
4571: IF g_timestamp3 + 30 >= g_timestamp1 AND g_exp_imp_prof_flag = 'Y' THEN --Copy records into Expense log table.
4572:
4573: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_EXP_T.';

Line 4573: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_EXP_T.';

4569: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
4570:
4571: IF g_timestamp3 + 30 >= g_timestamp1 AND g_exp_imp_prof_flag = 'Y' THEN --Copy records into Expense log table.
4572:
4573: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_EXP_T.';
4574: if g_debug_flag = 'Y' then
4575: fii_util.put_line(g_state);
4576: end if;
4577:

Line 4579: INSERT INTO FII_AP_DBI_LOG_EXP_T(

4575: fii_util.put_line(g_state);
4576: end if;
4577:
4578:
4579: INSERT INTO FII_AP_DBI_LOG_EXP_T(
4580: Table_Name,
4581: Operation_Flag,
4582: Key_Value1_ID,
4583: Key_Value2_ID,

Line 4598: FROM AP_DBI_LOG

4594: Last_Updated_By,
4595: Last_Update_Login,
4596: Creation_Date,
4597: Last_Update_Date
4598: FROM AP_DBI_LOG
4599: WHERE Partition_ID = i
4600: AND Creation_Date >= g_timestamp2
4601: AND Creation_Date < g_timestamp1;
4602: END IF;

Line 4605: EXECUTE IMMEDIATE 'ALTER TABLE ' || g_ap_schema || '.AP_DBI_LOG TRUNCATE PARTITION P' || to_char(i);

4601: AND Creation_Date < g_timestamp1;
4602: END IF;
4603:
4604: IF NOT (i = g_act_part1 OR i = g_act_part2) THEN --This is a non-active partition.
4605: EXECUTE IMMEDIATE 'ALTER TABLE ' || g_ap_schema || '.AP_DBI_LOG TRUNCATE PARTITION P' || to_char(i);
4606: END IF;
4607:
4608: END LOOP;
4609:

Line 4610: TRUNCATE_TABLE('FII_AP_DBI_LOG_PS_T');

4606: END IF;
4607:
4608: END LOOP;
4609:
4610: TRUNCATE_TABLE('FII_AP_DBI_LOG_PS_T');
4611:
4612: g_state := 'Truncating temp tables after used to populate base tables';
4613: -- TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
4614: -- TRUNCATE_TABLE('FII_AP_PAY_SCHED_ID);