APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ISC_DBI_TMP_WDD_LOG

Line 126: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WDD_LOG';

122:
123: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp tables');
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';

Line 668: INSERT INTO isc_dbi_tmp_wdd_log (DELIVERY_DETAIL_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)

664: l_total := 0;
665:
666: FII_UTIL.Start_Timer;
667:
668: INSERT INTO isc_dbi_tmp_wdd_log (DELIVERY_DETAIL_ID, LOG_ROWID, DML_TYPE, LAST_UPDATE_DATE)
669: SELECT delivery_detail_id, rowid LOG_ROWID, dml_type, last_update_date
670: FROM isc_dbi_wdd_change_log;
671:
672: FII_UTIL.Stop_Timer;

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

669: SELECT delivery_detail_id, rowid LOG_ROWID, dml_type, last_update_date
670: FROM isc_dbi_wdd_change_log;
671:
672: FII_UTIL.Stop_Timer;
673: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WDD_LOG');
674:
675: COMMIT;
676:
677: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 678: TABNAME => 'ISC_DBI_TMP_WDD_LOG');

674:
675: COMMIT;
676:
677: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
678: TABNAME => 'ISC_DBI_TMP_WDD_LOG');
679:
680: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
681: FII_UTIL.Start_Timer;
682:

Line 685: FROM isc_dbi_tmp_wdd_log log

681: FII_UTIL.Start_Timer;
682:
683: DELETE FROM isc_dbi_del_details_f
684: WHERE delivery_detail_id IN (SELECT DISTINCT log.delivery_detail_id
685: FROM isc_dbi_tmp_wdd_log log
686: WHERE NOT EXISTS (select '1' from wsh_delivery_details wdd
687: where wdd.delivery_detail_id = log.delivery_detail_id
688: and wdd.released_status in ('S','Y','C','L','P')));
689:

Line 730: FROM (select distinct delivery_detail_id from isc_dbi_tmp_wdd_log) log,

726: wdd.requested_quantity REQUESTED_QUANTITY,
727: wdd.requested_quantity_uom REQUESTED_QUANTITY_UOM,
728: wdd.shipped_quantity SHIPPED_QUANTITY,
729: mp.wms_enabled_flag WMS_ENABLED_FLAG
730: FROM (select distinct delivery_detail_id from isc_dbi_tmp_wdd_log) log,
731: wsh_delivery_details wdd,
732: wsh_delivery_assignments wda,
733: wsh_new_deliveries wnd,
734: mtl_txn_request_lines mol,

Line 3114: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_WDD_LOG';

3110:
3111: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp tables');
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';

Line 3439: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wdd_log);

3435: BIS_COLLECTION_UTILITIES.put_line('Deleting rows from log tables');
3436: FII_UTIL.Start_Timer;
3437:
3438: DELETE FROM ISC_DBI_WDD_CHANGE_LOG
3439: WHERE rowid IN (select log_rowid from isc_dbi_tmp_wdd_log);
3440: -- AND last_update_date < g_incre_start_date;
3441:
3442: FII_UTIL.Stop_Timer;
3443: FII_UTIL.Print_Timer('Deleted ' || sql%rowcount || ' rows from ISC_DBI_WDD_CHANGE_LOG in');