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.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_TMP_FIH_LOG

Line 128: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';

124: FII_UTIL.Start_Timer;
125:
126: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WDD_LOG';
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WTS_LOG';
128: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';
129:
130: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_DETAILS';
131: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';
132: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';

Line 1044: INSERT INTO isc_dbi_tmp_fih_log (INVOICE_HEADER_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)

1040: l_total := 0;
1041:
1042: FII_UTIL.Start_Timer;
1043:
1044: INSERT INTO isc_dbi_tmp_fih_log (INVOICE_HEADER_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)
1045: SELECT invoice_header_id, rowid LOG_ROWID, dml_type, last_update_date
1046: FROM isc_dbi_fih_change_log;
1047:
1048: FII_UTIL.Stop_Timer;

Line 1049: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_FIH_LOG');

1045: SELECT invoice_header_id, rowid LOG_ROWID, dml_type, last_update_date
1046: FROM isc_dbi_fih_change_log;
1047:
1048: FII_UTIL.Stop_Timer;
1049: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_FIH_LOG');
1050:
1051: COMMIT;
1052:
1053: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 1054: TABNAME => 'ISC_DBI_TMP_FIH_LOG');

1050:
1051: COMMIT;
1052:
1053: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
1054: TABNAME => 'ISC_DBI_TMP_FIH_LOG');
1055:
1056: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
1057: FII_UTIL.Start_Timer;
1058:

Line 1061: FROM isc_dbi_tmp_fih_log log

1057: FII_UTIL.Start_Timer;
1058:
1059: DELETE FROM isc_dbi_fte_invoices_f
1060: WHERE invoice_header_id IN (SELECT DISTINCT log.invoice_header_id
1061: FROM isc_dbi_tmp_fih_log log
1062: WHERE NOT EXISTS (select '1' from fte_invoice_headers fih
1063: where fih.invoice_header_id = log.invoice_header_id
1064: and fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')));
1065:

Line 1110: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,

1106: idl.delivery_leg_id DELIVERY_LEG_ID,
1107: idl.trip_id TRIP_ID,
1108: fih.currency_code TRX_CURRENCY_CODE,
1109: gsb.currency_code WH_CURRENCY_CODE
1110: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,
1111: fte_invoice_headers fih,
1112: wsh_document_instances wdi,
1113: isc_dbi_del_legs_f idl,
1114: ar_system_parameters_all aspa,

Line 1146: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,

1142: null DELIVERY_LEG_ID,
1143: itr.trip_id TRIP_ID,
1144: fih.currency_code TRX_CURRENCY_CODE,
1145: gsb.currency_code WH_CURRENCY_CODE
1146: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,
1147: fte_invoice_headers fih,
1148: wsh_document_instances wdi,
1149: isc_dbi_trip_stops_f itr,
1150: ar_system_parameters_all aspa,

Line 3116: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';

3112: FII_UTIL.Start_Timer;
3113:
3114: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WDD_LOG';
3115: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WTS_LOG';
3116: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_FIH_LOG';
3117:
3118: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_DETAILS';
3119: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_DEL_LEGS';
3120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_TRIP_STOPS';

Line 3748: WHERE rowid IN (select log_rowid from isc_dbi_tmp_fih_log);

3744:
3745: FII_UTIL.Start_Timer;
3746:
3747: DELETE FROM ISC_DBI_FIH_CHANGE_LOG
3748: WHERE rowid IN (select log_rowid from isc_dbi_tmp_fih_log);
3749: -- AND last_update_date < g_incre_start_date;
3750:
3751: FII_UTIL.Stop_Timer;
3752: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_FIH_CHANGE_LOG in');