APPS.EDW_DB_STATUS SQL Statements

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

Line: 155

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

Line: 180

		DBMS_SQL.PARSE(cid, 'SELECT 1 FROM sys.dual@'||l_db_link, dbms_sql.native);

Line: 218

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

Line: 240

	DBMS_SQL.PARSE(cid, 'SELECT 1 FROM sys.dual@'||l_db_link, dbms_sql.native);

Line: 290

		l_sql_stmt := ' SELECT 1 FROM  dual@edw_wh_to_rep';

Line: 311

        SELECT	inst_mod_id
	INTO	l_inst_mod_id
        FROM	wh_inst_mods_v@EDW_WH_TO_REP
        WHERE	sw_mod_type_code = 'DTWH';

Line: 318

	l_sql_stmt := 'SELECT	inst_mod_id FROM wh_inst_mods_v@edw_wh_to_rep 	WHERE sw_mod_type_code = ''DTWH''';

Line: 368

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

Line: 397

		/* First delete existing date from the source db */

		-- Check to see if the link points to itself


		IF ( edw_db_status.is_dblink_to_itself(l_db_link) = FALSE ) THEN

			l_progress := '030';

Line: 406

	                l_sql_stmt:=' DELETE '||p_table_name||'@'||l_db_link;

Line: 414

	          	l_sql_stmt:=' INSERT INTO  '||p_table_name||'@'||l_db_link||' SELECT * FROM '||p_table_name;

Line: 442

	SELECT warehouse_to_instance_link
	FROM   edw_source_instances_vl
	WHERE  enabled_flag = 'Y'
        AND instance_code=p_instance_code;

Line: 472

	        l_sql_stmt:=' DELETE '||p_table_name||'@'||l_db_link;

Line: 479

	 	l_sql_stmt:=' INSERT INTO  '||p_table_name||'@'||l_db_link
                             ||' SELECT * FROM '||p_table_name;

Line: 517

	l_stmt:='select upper(db.name) from v$database@'||p_dblink ||' db';

Line: 522

	SELECT upper(db.name)
	INTO   l_db_name
	FROM v$database db;