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.

VIEW: APPS.HXC_MAPPING_COMPONENTS_V

Source

View Text - Preformatted


SELECT mpc.rowid row_id, mpc.mapping_component_id, mpc.name, mpc.field_name, mpc.bld_blk_info_type_id, bbitu.building_block_category building_block_category, bbit.bld_blk_info_type bld_blk_info_type, mpc.segment, decode(mpc.segment,'ATTRIBUTE_CATEGORY','Attribute Category',dfcu.end_user_column_name), decode(mpc.segment,'ATTRIBUTE_CATEGORY','Y',dfcu.enabled_flag), mpc.object_version_number, mpc.created_by, mpc.creation_date, mpc.last_updated_by, mpc.last_update_date, mpc.last_update_login FROM fnd_descr_flex_column_usages dfcu, hxc_bld_blk_info_type_usages bbitu, hxc_bld_blk_info_types bbit, hxc_mapping_components mpc WHERE bbit.bld_blk_info_type_id = mpc.bld_blk_info_type_id AND bbitu.bld_blk_info_type_id = bbit.bld_blk_info_type_id AND dfcu.application_id = 809 AND dfcu.descriptive_flex_context_code = bbit.bld_blk_info_type and dfcu.descriptive_flexfield_name = 'OTC Information Types' AND ( (dfcu.application_column_name = mpc.segment and mpc.segment <> 'ATTRIBUTE_CATEGORY') OR (mpc.segment = 'ATTRIBUTE_CATEGORY' AND( (dfcu.application_column_name = (select dfcu2.application_column_name from fnd_descr_flex_column_usages dfcu2 where dfcu2.application_id = dfcu.application_id and dfcu2.descriptive_flexfield_name = dfcu.descriptive_flexfield_name and dfcu2.descriptive_flex_context_code = dfcu.descriptive_flex_context_code and rownum=1)) OR (not exists (select dfcu2.application_column_name from fnd_descr_flex_column_usages dfcu2 where dfcu2.application_id = dfcu.application_id and dfcu2.descriptive_flexfield_name = dfcu.descriptive_flexfield_name and dfcu2.descriptive_flex_context_code = dfcu.descriptive_flex_context_code )) ) ) )

View Text - HTML Formatted

SELECT MPC.ROWID ROW_ID
, MPC.MAPPING_COMPONENT_ID
, MPC.NAME
, MPC.FIELD_NAME
, MPC.BLD_BLK_INFO_TYPE_ID
, BBITU.BUILDING_BLOCK_CATEGORY BUILDING_BLOCK_CATEGORY
, BBIT.BLD_BLK_INFO_TYPE BLD_BLK_INFO_TYPE
, MPC.SEGMENT
, DECODE(MPC.SEGMENT
, 'ATTRIBUTE_CATEGORY'
, 'ATTRIBUTE CATEGORY'
, DFCU.END_USER_COLUMN_NAME)
, DECODE(MPC.SEGMENT
, 'ATTRIBUTE_CATEGORY'
, 'Y'
, DFCU.ENABLED_FLAG)
, MPC.OBJECT_VERSION_NUMBER
, MPC.CREATED_BY
, MPC.CREATION_DATE
, MPC.LAST_UPDATED_BY
, MPC.LAST_UPDATE_DATE
, MPC.LAST_UPDATE_LOGIN
FROM FND_DESCR_FLEX_COLUMN_USAGES DFCU
, HXC_BLD_BLK_INFO_TYPE_USAGES BBITU
, HXC_BLD_BLK_INFO_TYPES BBIT
, HXC_MAPPING_COMPONENTS MPC
WHERE BBIT.BLD_BLK_INFO_TYPE_ID = MPC.BLD_BLK_INFO_TYPE_ID
AND BBITU.BLD_BLK_INFO_TYPE_ID = BBIT.BLD_BLK_INFO_TYPE_ID
AND DFCU.APPLICATION_ID = 809
AND DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = BBIT.BLD_BLK_INFO_TYPE
AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME = 'OTC INFORMATION TYPES'
AND ( (DFCU.APPLICATION_COLUMN_NAME = MPC.SEGMENT
AND MPC.SEGMENT <> 'ATTRIBUTE_CATEGORY') OR (MPC.SEGMENT = 'ATTRIBUTE_CATEGORY' AND( (DFCU.APPLICATION_COLUMN_NAME = (SELECT DFCU2.APPLICATION_COLUMN_NAME
FROM FND_DESCR_FLEX_COLUMN_USAGES DFCU2
WHERE DFCU2.APPLICATION_ID = DFCU.APPLICATION_ID
AND DFCU2.DESCRIPTIVE_FLEXFIELD_NAME = DFCU.DESCRIPTIVE_FLEXFIELD_NAME
AND DFCU2.DESCRIPTIVE_FLEX_CONTEXT_CODE = DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND ROWNUM=1)) OR (NOT EXISTS (SELECT DFCU2.APPLICATION_COLUMN_NAME
FROM FND_DESCR_FLEX_COLUMN_USAGES DFCU2
WHERE DFCU2.APPLICATION_ID = DFCU.APPLICATION_ID
AND DFCU2.DESCRIPTIVE_FLEXFIELD_NAME = DFCU.DESCRIPTIVE_FLEXFIELD_NAME
AND DFCU2.DESCRIPTIVE_FLEX_CONTEXT_CODE = DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE )) ) ) )