APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on ISC_TMP_BOOK_SUM1

Line 416: SELECT isc_tmp_book_sum1_s.nextval

412: BEGIN
413:
414: p_count := 0;
415:
416: SELECT isc_tmp_book_sum1_s.nextval
417: INTO l_seq_id
418: FROM dual;
419:
420: -- --------------------------------------------

Line 421: -- Populate rowid into isc_tmp_book_sum1 table based

417: INTO l_seq_id
418: FROM dual;
419:
420: -- --------------------------------------------
421: -- Populate rowid into isc_tmp_book_sum1 table based
422: -- on header or line last update date and order booked date
423: -- --------------------------------------------
424:
425: INSERT

Line 426: INTO isc_tmp_book_sum1(

422: -- on header or line last update date and order booked date
423: -- --------------------------------------------
424:
425: INSERT
426: INTO isc_tmp_book_sum1(
427: PK1,
428: SEQ_ID)
429: SELECT /*+ PARALLEL(h) */
430: distinct to_char(h.header_id),

Line 584: DELETE isc_tmp_book_sum1

580: -- --------------------------------------------
581: -- Delete all temp tables' record
582: -- --------------------------------------------
583:
584: DELETE isc_tmp_book_sum1
585: WHERE seq_id IN ( l_seq_id_line );
586: COMMIT;
587:
588: IF (NOT LOCAL_SAME_AS_REMOTE) THEN

Line 713: DELETE isc_tmp_book_sum1

709: WHEN L_IDEN_CHANGE_FAILURE THEN
710: errbuf := g_errbuf;
711: retcode := g_retcode;
712: l_exception_msg := errbuf;
713: DELETE isc_tmp_book_sum1
714: WHERE seq_id IN ( l_seq_id_line);
715: COMMIT;
716: EDW_LOG.Put_Line('Identifying changed records has Failed : '|| l_exception_msg);
717: EDW_COLLECTION_UTIL.Wrapup(