APPS.OPI_UOM_WH_PUSH_PKG SQL Statements

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

Line: 6

        SELECT instance_code, warehouse_to_instance_link
        FROM   edw_source_instances_vl
        WHERE  enabled_flag = 'Y';

Line: 17

	dbms_sql.parse(cid, 'SELECT 1 FROM dual@'||p_db_link, dbms_sql.native);

Line: 78

				DBMS_SQL.PARSE(cid, 'DELETE EDW_MTL_LOCAL_UOM_M@'||l_db_link, dbms_sql.native);

Line: 81

				l_stmt :=  'INSERT INTO EDW_MTL_LOCAL_UOM_M@'||l_db_link||' (UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG,UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';

Line: 82

				l_stmt := l_stmt || ' SELECT UOM_EDW_UOM_PK, UOM_GLOBAL_FLAG, UOM_EDW_BASE_UOM, UOM_CONVERSION_RATE, SYSDATE, -1, SYSDATE, -1, -1 FROM EDW_MTL_UOM_M';

Line: 91

				DBMS_SQL.PARSE(cid, 'DELETE OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link, dbms_sql.native);

Line: 96

				l_stmt :=  'INSERT INTO OPI_EDW_LOCAL_UOM_CONV_F@'||l_db_link||' (UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE,CLASS_CONVERSION_FLAG,  LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN)';

Line: 97

				l_stmt := l_stmt || ' SELECT UOM_CONV_PK, EDW_BASE_UOM_FK, EDW_UOM_FK, EDW_CONVERSION_RATE,  CLASS_CONVERSION_FLAG, SYSDATE, -1, SYSDATE, -1, -1 FROM OPI_EDW_UOM_CONV_F';