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.ZX_FC_CODES_PKG SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_CLASSIFICATION_ID in NUMBER,
  X_Classification_Code in VARCHAR2,
  X_CLASSIFICATION_TYPE_CODE in VARCHAR2,
  X_PARENT_CLASSIFICATION_ID in NUMBER,
  X_PARENT_CLASSIFICATION_CODE in VARCHAR2,
  X_COUNTRY_CODE in VARCHAR2,
  X_Compiled_Flag in VARCHAR2,
  X_EFFECTIVE_FROM in DATE,
  X_EFFECTIVE_TO in DATE,
  X_REQUEST_ID in NUMBER,
  X_Record_Type_Code in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_CLASSIFICATION_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_Program_Login_Id in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
p_type_id	  ZX_FC_TYPES_VL.CLASSIFICATION_TYPE_ID%TYPE;

Line: 59


cursor C is select ROWID from ZX_FC_CODES_B
    where CLASSIFICATION_ID = X_CLASSIFICATION_ID ;

Line: 62


	SELECT
	TYPE.CLASSIFICATION_TYPE_ID,
	TYPE.CLASSIFICATION_TYPE_CODE,
	TYPE.CLASSIFICATION_TYPE_NAME,
	TYPE.Classification_Type_Categ_Code,
	TYPE.DELIMITER
	FROM ZX_FC_TYPES_VL TYPE
	WHERE TYPE.CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE;

Line: 71


	SELECT
            CONCAT_CLASSIF_CODE,CONCAT_CLASSIF_NAME,CLASSIFICATION_CODE_LEVEL,CLASSIFICATION_NAME,
	    SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,
	    SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
	    SEGMENT1_NAME,SEGMENT2_NAME,SEGMENT3_NAME,SEGMENT4_NAME,SEGMENT5_NAME,
	    SEGMENT6_NAME,SEGMENT7_NAME,SEGMENT8_NAME,SEGMENT9_NAME,SEGMENT10_NAME
	FROM
            ZX_FC_CODES_DENORM_B
        WHERE
            CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID AND
            LANGUAGE = userenv('LANG');

Line: 83


  insert into ZX_FC_CODES_B (
    CLASSIFICATION_ID,
    Classification_Code,
    CLASSIFICATION_TYPE_CODE,
    PARENT_CLASSIFICATION_ID,
    PARENT_CLASSIFICATION_CODE,
    COUNTRY_CODE,
    Compiled_Flag,
    EFFECTIVE_FROM,
    EFFECTIVE_TO,
    REQUEST_ID,
    Record_Type_Code,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID ,
    Program_Login_Id,
    OBJECT_VERSION_NUMBER
  ) values (
    X_CLASSIFICATION_ID,
    X_Classification_Code,
    X_CLASSIFICATION_TYPE_CODE,
    X_PARENT_CLASSIFICATION_ID,
    X_PARENT_CLASSIFICATION_CODE,
    X_COUNTRY_CODE,
    X_Compiled_Flag,
    X_EFFECTIVE_FROM,
    X_EFFECTIVE_TO,
    X_REQUEST_ID,
    X_Record_Type_Code,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE_CATEGORY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_ID,
    X_Program_Login_Id,
    X_OBJECT_VERSION_NUMBER
  );

Line: 158


  insert into ZX_FC_CODES_TL (
    CLASSIFICATION_ID,
    CLASSIFICATION_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CLASSIFICATION_ID,
    X_CLASSIFICATION_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from ZX_FC_CODES_TL T
    where T.CLASSIFICATION_ID = X_CLASSIFICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 249


INSERT INTO Zx_Fc_Codes_Denorm_B(
    CLASSIFICATION_TYPE_ID,
    CLASSIFICATION_TYPE_CODE,
    CLASSIFICATION_TYPE_NAME,
    Classification_Type_Categ_Code,
    CLASSIFICATION_ID,
    Classification_Code,
    CLASSIFICATION_NAME,
    LANGUAGE,
    EFFECTIVE_FROM,
    EFFECTIVE_TO,
    Enabled_Flag,
    ANCESTOR_ID,
    ANCESTOR_CODE,
    ANCESTOR_NAME,
    CONCAT_CLASSIF_CODE,
    CONCAT_CLASSIF_NAME,
    CLASSIFICATION_CODE_LEVEL,
    COUNTRY_CODE,
    SEGMENT1,
    SEGMENT2,
    SEGMENT3,
    SEGMENT4,
    SEGMENT5,
    SEGMENT6,
    SEGMENT7,
    SEGMENT8,
    SEGMENT9,
    SEGMENT10,
    SEGMENT1_NAME,
    SEGMENT2_NAME,
    SEGMENT3_NAME,
    SEGMENT4_NAME,
    SEGMENT5_NAME,
    SEGMENT6_NAME,
    SEGMENT7_NAME,
    SEGMENT8_NAME,
    SEGMENT9_NAME,
    SEGMENT10_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    Program_Login_Id,
    Record_Type_Code)
SELECT
    p_type_id,
    p_type_code,
    p_type_name,
    p_type_categ,
    X_CLASSIFICATION_ID,
    X_Classification_Code,
    X_CLASSIFICATION_NAME,
    L.LANGUAGE_CODE,
    X_EFFECTIVE_FROM,
    X_EFFECTIVE_TO,
    'Y',
    X_PARENT_CLASSIFICATION_ID,
    X_PARENT_CLASSIFICATION_CODE,
    p_parent_name,
    p_concat_code,
    p_concat_name,
    p_code_level,
    X_COUNTRY_CODE,
    p_seg(1),
    p_seg(2),
    p_seg(3),
    p_seg(4),
    p_seg(5),
    p_seg(6),
    p_seg(7),
    p_seg(8),
    p_seg(9),
    p_seg(10),
    p_seg_name(1),
    p_seg_name(2),
    p_seg_name(3),
    p_seg_name(4),
    p_seg_name(5),
    p_seg_name(6),
    p_seg_name(7),
    p_seg_name(8),
    p_seg_name(9),
    p_seg_name(10),
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_Program_Login_Id,
    X_Record_Type_Code
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from Zx_Fc_Codes_Denorm_B Denorm
    where Denorm.CLASSIFICATION_ID = X_CLASSIFICATION_ID
    and Denorm.LANGUAGE = L.LANGUAGE_CODE);

Line: 355


end INSERT_ROW;

Line: 391


  cursor c is select
      Classification_Code,
      CLASSIFICATION_TYPE_CODE,
      PARENT_CLASSIFICATION_ID,
      PARENT_CLASSIFICATION_CODE,
      COUNTRY_CODE,
      Compiled_Flag,
      EFFECTIVE_FROM,
      EFFECTIVE_TO,
      REQUEST_ID,
      Record_Type_Code,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      Program_Login_Id  ,
      OBJECT_VERSION_NUMBER
    from ZX_FC_CODES_B
    where CLASSIFICATION_ID = X_CLASSIFICATION_ID
    for update of CLASSIFICATION_ID nowait;

Line: 426


  cursor c1 is select
      CLASSIFICATION_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from ZX_FC_CODES_TL
    where CLASSIFICATION_ID = X_CLASSIFICATION_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of CLASSIFICATION_ID nowait;

Line: 438


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 519


procedure UPDATE_ROW (
  X_CLASSIFICATION_ID in NUMBER,
  X_Classification_Code in VARCHAR2,
  X_CLASSIFICATION_TYPE_CODE in VARCHAR2,
  X_PARENT_CLASSIFICATION_ID in NUMBER,
  X_PARENT_CLASSIFICATION_CODE in VARCHAR2,
  X_COUNTRY_CODE in VARCHAR2,
  X_Compiled_Flag in VARCHAR2,
  X_EFFECTIVE_FROM in DATE,
  X_EFFECTIVE_TO in DATE,
  X_REQUEST_ID in NUMBER,
  X_Record_Type_Code in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_CLASSIFICATION_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_Program_Login_Id in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
p_delimiter	  ZX_FC_TYPES_VL.DELIMITER%TYPE;

Line: 559


  update ZX_FC_CODES_B set
    Classification_Code = X_Classification_Code,
    CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE,
    PARENT_CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID,
    PARENT_CLASSIFICATION_CODE = X_PARENT_CLASSIFICATION_CODE,
    COUNTRY_CODE = X_COUNTRY_CODE,
    Compiled_Flag = X_Compiled_Flag,
    EFFECTIVE_FROM = X_EFFECTIVE_FROM,
    EFFECTIVE_TO = X_EFFECTIVE_TO,
    REQUEST_ID = X_REQUEST_ID,
    Record_Type_Code = X_Record_Type_Code,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID=X_PROGRAM_APPLICATION_ID ,
    PROGRAM_ID=X_PROGRAM_ID ,
    Program_Login_Id=X_Program_Login_Id,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
  where CLASSIFICATION_ID = X_CLASSIFICATION_ID;

Line: 597


  update ZX_FC_CODES_TL set
    CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where CLASSIFICATION_ID = X_CLASSIFICATION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 611


      select DELIMITER into p_delimiter FROM ZX_FC_TYPES_B WHERE
   	   CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE;

Line: 613


      select CONCAT_CLASSIF_NAME into p_concat_name from
    	  Zx_Fc_Codes_Denorm_B CodeDenorm where CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID
	  and userenv('LANG') in (LANGUAGE);

Line: 618


  update Zx_Fc_Codes_Denorm_B set
    COUNTRY_CODE	= X_COUNTRY_CODE,
    EFFECTIVE_TO	= X_EFFECTIVE_TO,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID=X_PROGRAM_APPLICATION_ID ,
    PROGRAM_ID=X_PROGRAM_ID ,
    Program_Login_Id=X_Program_Login_Id
    where CLASSIFICATION_ID = X_CLASSIFICATION_ID;

Line: 629


  update Zx_Fc_Codes_Denorm_B set
    CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
    CONCAT_CLASSIF_NAME = p_concat_name || p_delimiter || X_CLASSIFICATION_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID=X_PROGRAM_APPLICATION_ID ,
    PROGRAM_ID=X_PROGRAM_ID ,
    Program_Login_Id=X_Program_Login_Id
    where CLASSIFICATION_ID = X_CLASSIFICATION_ID
    and userenv('LANG') in (LANGUAGE);

Line: 641


end UPDATE_ROW;

Line: 643


procedure DELETE_ROW (
  X_CLASSIFICATION_ID in NUMBER
) is
begin
  delete from ZX_FC_CODES_TL
  where CLASSIFICATION_ID = X_CLASSIFICATION_ID;

Line: 652


  delete from ZX_FC_CODES_B
  where CLASSIFICATION_ID = X_CLASSIFICATION_ID;

Line: 657


end DELETE_ROW;

Line: 662


  delete from ZX_FC_CODES_TL T
  where not exists
    (select NULL
    from ZX_FC_CODES_B B
    where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
    );

Line: 668


  update ZX_FC_CODES_TL T set (
      CLASSIFICATION_NAME
    ) = (select
      B.CLASSIFICATION_NAME
    from ZX_FC_CODES_TL B
    where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CLASSIFICATION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CLASSIFICATION_ID,
      SUBT.LANGUAGE
    from ZX_FC_CODES_TL SUBB, ZX_FC_CODES_TL SUBT
    where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
  ));

Line: 686


  insert into ZX_FC_CODES_TL (
    CLASSIFICATION_ID,
    CLASSIFICATION_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CLASSIFICATION_ID,
    B.CLASSIFICATION_NAME,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from ZX_FC_CODES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ZX_FC_CODES_TL T
    where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 715


/* Logic to delete/update/insert into zx_fc_codes_denorm_b table */

  delete from ZX_FC_CODES_DENORM_B T
  where not exists
    (select NULL
    from ZX_FC_CODES_B B
    where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
    );

Line: 727


  update ZX_FC_CODES_DENORM_B T set (
      CLASSIFICATION_NAME
    ) = (select
      B.CLASSIFICATION_NAME
    from ZX_FC_CODES_DENORM_B B
    where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CLASSIFICATION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CLASSIFICATION_ID,
      SUBT.LANGUAGE
    from ZX_FC_CODES_DENORM_B SUBB, ZX_FC_CODES_DENORM_B SUBT
    where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
  ));

Line: 747


  insert into ZX_FC_CODES_DENORM_B (
    CLASSIFICATION_ID,
    CLASSIFICATION_CODE,
    CLASSIFICATION_NAME,
    CLASSIFICATION_TYPE_ID,
    CLASSIFICATION_TYPE_CODE,
    CLASSIFICATION_TYPE_NAME,
    CLASSIFICATION_TYPE_CATEG_CODE,
    EFFECTIVE_FROM,
    EFFECTIVE_TO,
    ENABLED_FLAG,
    ANCESTOR_ID,
    ANCESTOR_CODE,
    ANCESTOR_NAME,
    CONCAT_CLASSIF_CODE,
    CONCAT_CLASSIF_NAME,
    CLASSIFICATION_CODE_LEVEL,
    COUNTRY_CODE,
    SEGMENT1,
    SEGMENT2,
    SEGMENT3,
    SEGMENT4,
    SEGMENT5,
    SEGMENT6,
    SEGMENT7,
    SEGMENT8,
    SEGMENT9,
    SEGMENT10,
    SEGMENT1_NAME,
    SEGMENT2_NAME,
    SEGMENT3_NAME,
    SEGMENT4_NAME,
    SEGMENT5_NAME,
    SEGMENT6_NAME,
    SEGMENT7_NAME,
    SEGMENT8_NAME,
    SEGMENT9_NAME,
    SEGMENT10_NAME,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_LOGIN_ID,
    RECORD_TYPE_CODE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE
  ) select
    B.CLASSIFICATION_ID,
    B.CLASSIFICATION_CODE,
    B.CLASSIFICATION_NAME,
    B.CLASSIFICATION_TYPE_ID,
    B.CLASSIFICATION_TYPE_CODE,
    B.CLASSIFICATION_TYPE_NAME,
    B.CLASSIFICATION_TYPE_CATEG_CODE,
    B.EFFECTIVE_FROM,
    B.EFFECTIVE_TO,
    B.ENABLED_FLAG,
    B.ANCESTOR_ID,
    B.ANCESTOR_CODE,
    B.ANCESTOR_NAME,
    B.CONCAT_CLASSIF_CODE,
    B.CONCAT_CLASSIF_NAME,
    B.CLASSIFICATION_CODE_LEVEL,
    B.COUNTRY_CODE,
    B.SEGMENT1,
    B.SEGMENT2,
    B.SEGMENT3,
    B.SEGMENT4,
    B.SEGMENT5,
    B.SEGMENT6,
    B.SEGMENT7,
    B.SEGMENT8,
    B.SEGMENT9,
    B.SEGMENT10,
    B.SEGMENT1_NAME,
    B.SEGMENT2_NAME,
    B.SEGMENT3_NAME,
    B.SEGMENT4_NAME,
    B.SEGMENT5_NAME,
    B.SEGMENT6_NAME,
    B.SEGMENT7_NAME,
    B.SEGMENT8_NAME,
    B.SEGMENT9_NAME,
    B.SEGMENT10_NAME,
    B.REQUEST_ID,
    B.PROGRAM_ID,
    B.PROGRAM_APPLICATION_ID,
    B.PROGRAM_LOGIN_ID,
    B.RECORD_TYPE_CODE,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE
  from ZX_FC_CODES_DENORM_B B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ZX_FC_CODES_DENORM_B T
    where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);