eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EC_CODE_CONVERSION_PVT SQL Statements

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

Line: 39


	SELECT  XREF_INT_VALUE
	FROM	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NOT NULL AND
                XREF_KEY2 IS NOT NULL AND
		XREF_KEY3 IS NOT NULL AND
		XREF_KEY4 IS NOT NULL AND
		XREF_KEY5 IS NOT NULL AND
		XREF_KEY1 = p_Key1 AND
		XREF_KEY2 = p_Key2 AND
		XREF_KEY3 = p_Key3 AND
		XREF_KEY4 = p_Key4 AND
		XREF_KEY5 = p_Key5 AND
		XREF_CATEGORY_CODE = p_Category AND
		XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
		NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
		NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
		NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
		NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 60


	SELECT	XREF_INT_VALUE
	FROM 	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NOT NULL AND
                XREF_KEY2 IS NOT NULL AND
                XREF_KEY3 IS NOT NULL AND
                XREF_KEY4 IS NOT NULL AND
                XREF_KEY5 IS NULL AND
                XREF_KEY1 = p_Key1 AND
                XREF_KEY2 = p_Key2 AND
                XREF_KEY3 = p_Key3 AND
                XREF_KEY4 = p_Key4 AND
                XREF_CATEGORY_CODE = p_Category AND
                XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
                NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 80


	SELECT	XREF_INT_VALUE
	FROM	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NOT NULL AND
                XREF_KEY2 IS NOT NULL AND
                XREF_KEY3 IS NOT NULL AND
                XREF_KEY4 IS NULL AND
                XREF_KEY5 IS NULL AND
                XREF_KEY1 = p_Key1 AND
                XREF_KEY2 = p_Key2 AND
                XREF_KEY3 = p_Key3 AND
                XREF_CATEGORY_CODE = p_Category AND
                XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
                NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 99


	SELECT	XREF_INT_VALUE
	FROM	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NOT NULL AND
                XREF_KEY2 IS NOT NULL AND
                XREF_KEY3 IS NULL AND
                XREF_KEY4 IS NULL AND
                XREF_KEY5 IS NULL AND
                XREF_KEY1 = p_Key1 AND
                XREF_KEY2 = p_Key2 AND
                XREF_CATEGORY_CODE = p_Category AND
                XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
                NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 117


	SELECT	XREF_INT_VALUE
	FROM	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NOT NULL AND
                XREF_KEY2 IS NULL AND
                XREF_KEY3 IS NULL AND
                XREF_KEY4 IS NULL AND
                XREF_KEY5 IS NULL AND
                XREF_KEY1 = p_Key1 AND
                XREF_CATEGORY_CODE = p_Category AND
                XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
                NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 134


	SELECT	XREF_INT_VALUE
	FROM	ECE_XREF_DATA
	WHERE	XREF_KEY1 IS NULL AND
                XREF_KEY2 IS NULL AND
                XREF_KEY3 IS NULL AND
                XREF_KEY4 IS NULL AND
                XREF_KEY5 IS NULL AND
                XREF_CATEGORY_CODE = p_Category AND
                XREF_EXT_VALUE1    = p_Ext_val1 AND
		(DIRECTION = 'IN' or DIRECTION = 'BOTH') AND
                NVL(XREF_EXT_VALUE2,FND_API.G_MISS_CHAR) = NVL(p_Ext_val2, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE3,FND_API.G_MISS_CHAR) = NVL(p_Ext_val3, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE4,FND_API.G_MISS_CHAR) = NVL(p_Ext_val4, FND_API.G_MISS_CHAR) AND
                NVL(XREF_EXT_VALUE5,FND_API.G_MISS_CHAR) = NVL(p_Ext_val5, FND_API.G_MISS_CHAR);

Line: 448


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NOT NULL AND
              XREF_KEY2 IS NOT NULL AND
              XREF_KEY3 IS NOT NULL AND
              XREF_KEY4 IS NOT NULL AND
              XREF_KEY5 IS NOT NULL AND
              XREF_KEY1 = p_Key1 AND
              XREF_KEY2 = p_Key2 AND
              XREF_KEY3 = p_Key3 AND
              XREF_KEY4 = p_Key4 AND
              XREF_KEY5 = p_Key5 AND
              XREF_INT_VALUE     = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 469


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NOT NULL AND
              XREF_KEY2 IS NOT NULL AND
              XREF_KEY3 IS NOT NULL AND
              XREF_KEY4 IS NOT NULL AND
              XREF_KEY5 IS NULL AND
              XREF_KEY1 = p_Key1 AND
              XREF_KEY2 = p_Key2 AND
              XREF_KEY3 = p_Key3 AND
              XREF_KEY4 = p_Key4 AND
              XREF_INT_VALUE     = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 489


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NOT NULL AND
              XREF_KEY2 IS NOT NULL AND
              XREF_KEY3 IS NOT NULL AND
              XREF_KEY4 IS NULL AND
              XREF_KEY5 IS NULL AND
              XREF_KEY1 = p_Key1 AND
              XREF_KEY2 = p_Key2 AND
              XREF_KEY3 = p_Key3 AND
              XREF_INT_VALUE     = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 508


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NOT NULL AND
              XREF_KEY2 IS NOT NULL AND
              XREF_KEY3 IS NULL AND
              XREF_KEY4 IS NULL AND
              XREF_KEY5 IS NULL AND
              XREF_KEY1 = p_Key1 AND
              XREF_KEY2 = p_Key2 AND
              XREF_INT_VALUE = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 526


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NOT NULL AND
              XREF_KEY2 IS NULL AND
              XREF_KEY3 IS NULL AND
              XREF_KEY4 IS NULL AND
              XREF_KEY5 IS NULL AND
              XREF_KEY1 = p_Key1 AND
              XREF_INT_VALUE     = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 543


      SELECT  XREF_EXT_VALUE1,
              XREF_EXT_VALUE2,
              XREF_EXT_VALUE3,
              XREF_EXT_VALUE4,
              XREF_EXT_VALUE5
      FROM    ECE_XREF_DATA
      WHERE   XREF_KEY1 IS NULL AND
              XREF_KEY2 IS NULL AND
              XREF_KEY3 IS NULL AND
              XREF_KEY4 IS NULL AND
              XREF_KEY5 IS NULL AND
              XREF_INT_VALUE     = p_Int_val AND
              XREF_CATEGORY_CODE = p_Category AND
              (DIRECTION = 'OUT' or DIRECTION = 'BOTH');

Line: 941


	SELECT	  key1_used_flag, key2_used_flag, key3_used_flag,
                  key4_used_flag, key5_used_flag,
                  key1_used_table, key2_used_table, key3_used_table,
                  key4_used_table, key5_used_table,
                  key1_used_column, key2_used_column, key3_used_column,
                  key4_used_column, key5_used_column,
                  xref_category_code
	INTO	  ckey1_used_flag, ckey2_used_flag, ckey3_used_flag,
                  ckey4_used_flag, ckey5_used_flag,
                  ckey1_used_table, ckey2_used_table, ckey3_used_table,
                  ckey4_used_table, ckey5_used_table,
                  ckey1_used_column, ckey2_used_column, ckey3_used_column,
                  ckey4_used_column, ckey5_used_column,
                  cxref_category_code
	FROM	  ece_xref_categories
	WHERE	  ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;

Line: 1311


	SELECT	  key1_used_flag, key2_used_flag, key3_used_flag,
                  key4_used_flag, key5_used_flag,
                  key1_used_table, key2_used_table, key3_used_table,
                  key4_used_table, key5_used_table,
                  key1_used_column, key2_used_column, key3_used_column,
                  key4_used_column, key5_used_column,
                  xref_category_code
	INTO	  ckey1_used_flag, ckey2_used_flag, ckey3_used_flag,
                  ckey4_used_flag, ckey5_used_flag,
                  ckey1_used_table, ckey2_used_table, ckey3_used_table,
                  ckey4_used_table, ckey5_used_table,
                  ckey1_used_column, ckey2_used_column, ckey3_used_column,
                  ckey4_used_column, ckey5_used_column,
                  cxref_category_code
	FROM	  ece_xref_categories
	WHERE	  ece_xref_categories.xref_category_id = p_tbl(i).xref_category_id;

Line: 1702


          /* Debugging Code: DO NOT DELETE! */
	/*
	BEGIN
        INSERT INTO ece_error(run_id, line_id, text)
			VALUES(
				81,
				ece_error_s.nextval,
				'Rec =' || p_apps_tbl(j).record_num ||
				'- Pos= ' || p_apps_tbl(j).Position ||
				'- Val=' || p_apps_tbl(j).extvalue ||
				' Width= ' || p_apps_tbl(j).data_length ||
				' Int Col= '|| p_apps_tbl(j).interface_column_name ||
				'- Apps col= ' || p_apps_tbl(j).base_column_name ||
				'- val= '|| p_apps_tbl(j).value);

Line: 1822


            SELECT  key1_used_flag, key2_used_flag, key3_used_flag,
                    key4_used_flag, key5_used_flag,
                    key1_used_table, key2_used_table, key3_used_table,
                    key4_used_table, key5_used_table,
                    key1_used_column, key2_used_column, key3_used_column,
                    key4_used_column, key5_used_column,
                    xref_category_code
            INTO    ckey1_used_flag, ckey2_used_flag, ckey3_used_flag,
                    ckey4_used_flag, ckey5_used_flag,
                    ckey1_used_table, ckey2_used_table, ckey3_used_table,
                    ckey4_used_table, ckey5_used_table,
                    ckey1_used_column, ckey2_used_column, ckey3_used_column,
                    ckey4_used_column, ckey5_used_column,
                    cxref_category_code
            FROM    ece_xref_categories
            WHERE   ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;

Line: 1914


            /* Debugging Code: DO NOT DELETE! */
            /*
            IF (debug_mode_on_int) THEN
              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'xref code =' || cxref_category_code);

Line: 1918


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'column =' || p_apps_tbl(j).interface_column_name);

Line: 1919


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'key 1 =' || key1);

Line: 1920


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'key 2 =' || key2);

Line: 1921


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'key 3 =' || key3);

Line: 1922


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'key 4 =' || key4);

Line: 1923


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'key 5 =' || key5);

Line: 1924


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'ext 1 =' || c_ext_value1);

Line: 1925


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'ext 2 =' || c_ext_value2);

Line: 1926


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'ext 3 =' || c_ext_value3);

Line: 1927


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'ext 4 =' || c_ext_value4);

Line: 1928


              INSERT INTO ece_error VALUES (431, ece_error_s.nextval, 'ext 5 =' || c_ext_value5);

Line: 2287


            SELECT  key1_used_flag, key2_used_flag, key3_used_flag,
                    key4_used_flag, key5_used_flag,
                    key1_used_table, key2_used_table, key3_used_table,
                    key4_used_table, key5_used_table,
                    key1_used_column, key2_used_column, key3_used_column,
                    key4_used_column, key5_used_column,
                    xref_category_code
            INTO    ckey1_used_flag, ckey2_used_flag, ckey3_used_flag,
                    ckey4_used_flag, ckey5_used_flag,
                    ckey1_used_table, ckey2_used_table, ckey3_used_table,
                    ckey4_used_table, ckey5_used_table,
                    ckey1_used_column, ckey2_used_column, ckey3_used_column,
                    ckey4_used_column, ckey5_used_column,
                    cxref_category_code
            FROM    ece_xref_categories
            WHERE   ece_xref_categories.xref_category_id = p_apps_tbl(j).xref_category_id;