APPS.ISC_EDW_BOOK_DEL_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

  EDW_OWB_COLLECTION_UTIL.Write_To_Log_File('Going to insert into ISC_EDW_BOOK_DEL table');

Line: 30

  l_stmt :=	'INSERT INTO '||l_isc_owner||'.ISC_EDW_BOOK_DEL'||
		'     SELECT book.bookings_pk, book.line_id, inst.inst_instance_pk'||
		'	FROM ISC_EDW_BOOKINGS_F 	book,'||
		'	     EDW_INSTANCE_M 		inst'||
		'      WHERE book.fulfillment_flag = ''N'''||
		'	 AND book.instance_fk_key = inst.inst_instance_pk_key';

Line: 38

  EDW_OWB_COLLECTION_UTIL.Write_To_Log_File('Finished inserting into the table ISC_EDW_BOOK_DEL');

Line: 41

  l_stmt := 'SELECT count(*) FROM ISC_EDW_BOOK_DEL';

Line: 44

  EDW_OWB_COLLECTION_UTIL.Write_To_Log_File('Inserted '|| nvl(l_number_rows,0) ||' rows into ISC_EDW_BOOK_DEL.');