Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_MAPPING_COMPONENTS_V |
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 )) ) ) )