APPS.ISC_EDW_BACKLOG_SUM1_F_C SQL Statements

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

Line: 50

    SELECT edw.instance_code,
	   edw.warehouse_to_instance_link
    FROM   edw_source_instances edw
    WHERE  edw.enabled_flag = 'Y';

Line: 65

  SELECT tablespace_name
  INTO   g_tablespace
  FROM   all_tables
  WHERE  table_name = 'ISC_EDW_BACKLOG_SUM1_F'
  AND    owner = g_isc_schema;

Line: 76

  select  name
  into	  l_db_name1
  from    v$database;

Line: 91

      l_stmt := 'SELECT SET_OF_BOOKS_ID FROM ISCBV_EDW_BACKLOG_SUM1_FCV@'
		      ||g_rec(i).db_link
		      ||' WHERE ROWNUM < 2';

Line: 106

	    l_stmt := 'SELECT instance_code from edw_local_instance@'||g_rec(i).db_link;

Line: 132

      THEN  l_stmt := 'SELECT name '||'FROM v$database@'||g_rec(i).db_link;

Line: 247

      l_stmt := 'INSERT INTO '||g_isc_schema||'.ISC_EDW_BACK_SUM1_SUMM T
	(BACKLOG_SUM1_PK,
	CUSTOMER_ID,
	FUNCTIONAL_CURRENCY,
	INSTANCE_CODE,
	SET_OF_BOOKS_ID,
	OPERATING_UNIT_ID,
	DAYS_OPEN,
	DLQT_BKLG_AMT_B,
	DLQT_BKLG_AMT_G,
	DLQT_BKLG_LINE_COUNT,
	MAX_DAYS_LATE,
	SHIP_BKLG_AMT_B,
	SHIP_BKLG_AMT_G,
	SHIP_BKLG_LINE_COUNT,
	DATE_BOOKED,
	DATE_OF_SNAPSHOT,
	HEADER_ID,
	ORDER_NUMBER)
      SELECT /*+ DRIVING_SITE(BACK) */
	BACKLOG_SUM1_PK,
	CUSTOMER_ID,
	FUNCTIONAL_CURRENCY,
	INSTANCE_CODE,
	SET_OF_BOOKS_ID,
	OPERATING_UNIT_ID,
	DAYS_OPEN,
	DLQT_BKLG_AMT_B,
	DLQT_BKLG_AMT_G,
	DLQT_BKLG_LINE_COUNT,
	MAX_DAYS_LATE,
	SHIP_BKLG_AMT_B,
	SHIP_BKLG_AMT_G,
	SHIP_BKLG_LINE_COUNT,
	DATE_BOOKED,
	DATE_OF_SNAPSHOT,
	HEADER_ID,
	ORDER_NUMBER
      FROM ISCBV_EDW_BACKLOG_SUM1_FCV';

Line: 329

  l_stmt := 'INSERT INTO ISC_EDW_BACKLOG_SUM1_F (
	 	  BACKLOG_SUM1_PK,
	 	  CREATION_DATE,
	 	  LAST_UPDATE_DATE,
	 	  CUSTOMER_FK_KEY,
	 	  FUNCTIONAL_CURRENCY_FK_KEY,
	 	  INSTANCE_FK_KEY,
	 	  SET_OF_BOOKS_FK_KEY,
	 	  OPERATING_UNIT_FK_KEY,
	 	  DAYS_OPEN,
	 	  DLQT_BKLG_AMT_B,
	 	  DLQT_BKLG_AMT_G,
	 	  DLQT_BKLG_LINE_COUNT,
	 	  MAX_DAYS_LATE,
	 	  SHIP_BKLG_AMT_B,
	 	  SHIP_BKLG_AMT_G,
	 	  SHIP_BKLG_LINE_COUNT,
	 	  CUSTOMER_NAME,
	 	  DATE_BOOKED,
	 	  DATE_OF_SNAPSHOT,
	 	  HEADER_ID,
	 	  INSTANCE_CODE,
	 	  OPERATING_UNIT_NAME,
	 	  ORDER_NUMBER)
	     SELECT summary.BACKLOG_SUM1_PK,
		    SYSDATE,
		    SYSDATE,
		    cust.TPRT_TRADE_PARTNER_PK_KEY,
		    curr.CRNC_CURRENCY_PK_KEY,
		    inst.INST_INSTANCE_PK_KEY,
		    sob.FABK_FA_BOOK_PK_KEY,
		    org.OPER_OPERATING_UNIT_PK_KEY,
		    summary.DAYS_OPEN,
		    summary.DLQT_BKLG_AMT_B,
		    summary.DLQT_BKLG_AMT_G,
		    summary.DLQT_BKLG_LINE_COUNT,
		    summary.MAX_DAYS_LATE,
		    summary.SHIP_BKLG_AMT_B,
		    summary.SHIP_BKLG_AMT_G,
		    summary.SHIP_BKLG_LINE_COUNT,
		    cust.TPRT_NAME,
		    summary.DATE_BOOKED,
		    summary.DATE_OF_SNAPSHOT,
		    summary.HEADER_ID,
		    summary.INSTANCE_CODE,
		    org.OPER_NAME,
		    summary.ORDER_NUMBER
	     FROM '||g_isc_schema||'.ISC_EDW_BACK_SUM1_SUMM 	summary,
		  edw_instance_m				inst,
		  edw_currency_m				curr,
		  edw_gl_book_m					sob,
		  edw_organization_m				org,
		  edw_trd_partner_m				cust
	     WHERE sob.fabk_fa_book_pk
		     = summary.set_of_books_id||''-''||summary.instance_code
	       AND inst.inst_instance_pk = summary.instance_code
	       AND cust.tplo_tpartner_loc_pk
		     = summary.customer_id||''-''||summary.instance_code||''-CUST_ACCT-TPRT''
	       AND org.orga_organization_pk
		     = summary.operating_unit_id||''-''||summary.instance_code
	       AND curr.crnc_currency_pk = summary.functional_currency';