View: HXC_TIME_CATEGORY_COMPS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_TIME_CATEGORY_COMPS_V

View Text

SELECT TCC.ROWID ROW_ID
, TCC.TIME_CATEGORY_COMP_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TIME_CATEGORY_ID
, TCC.REF_TIME_CATEGORY_ID
, NULL TIME_CATEGORY_NAME
, NULL TIME_CATEGORY_DESCRIPTION
, NULL REF_OPERATOR
, TCC.TYPE
, TCC.COMPONENT_TYPE_ID
, TCC.FLEX_VALUE_SET_ID
, TCC.EQUAL_TO
, TCC.IS_NULL
, LK.MEANING IS_NULL_MEANING
, TCC.VALUE_ID
, DECODE( TCC.VALUE_ID
, NULL
, NULL
, HXC_TIME_CATEGORY_UTILS_PKG.GET_FLEX_VALUE (TCC.FLEX_VALUE_SET_ID
, TCC.VALUE_ID)) VALUE
, MPC.SEGMENT
, MPC.BLD_BLK_INFO_TYPE CONTEXT
, MPC.BUILDING_BLOCK_CATEGORY CATEGORY
, MPC.END_USER_COLUMN_NAME
, MPC.NAME MAPPING_COMPONENT_NAME
, NULL AN_CONTEXT
, NULL AN_CONTEXT_MEANING
, NULL ALIAS_VALUE_NAME
, NULL VALUE_SET_NAME
, NULL FORMULA_NAME
, NULL FORMULA_DESCRIPTION
, TCC.CREATED_BY
, TCC.CREATION_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATE_LOGIN
FROM HXC_MAPPING_COMPONENTS_V MPC
, HXC_TIME_CATEGORY_COMPS TCC
, HR_LOOKUPS LK
WHERE TCC.TYPE = 'MC'
AND MPC.MAPPING_COMPONENT_ID = TCC.COMPONENT_TYPE_ID
AND LK.LOOKUP_TYPE = 'HXC_TIME_CATEGORY_IS_NULL'
AND LK.LOOKUP_CODE = TCC.IS_NULL UNION SELECT TCC.ROWID ROW_ID
, TCC.TIME_CATEGORY_COMP_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TIME_CATEGORY_ID
, TCC.REF_TIME_CATEGORY_ID
, NULL TIME_CATEGORY_NAME
, NULL TIME_CATEGORY_DESCRIPTION
, NULL REF_OPERATOR
, TCC.TYPE
, TCC.COMPONENT_TYPE_ID
, TCC.FLEX_VALUE_SET_ID
, TCC.EQUAL_TO
, TCC.IS_NULL
, LK.MEANING IS_NULL_MEANING
, TCC.VALUE_ID
, NULL VALUE
, MPC.SEGMENT
, MPC.BLD_BLK_INFO_TYPE CONTEXT
, MPC.BUILDING_BLOCK_CATEGORY CATEGORY
, MPC.END_USER_COLUMN_NAME
, MPC.NAME MAPPING_COMPONENT_NAME
, NULL AN_CONTEXT
, NULL AN_CONTEXT_MEANING
, NULL ALIAS_VALUE_NAME
, FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, NULL FORMULA_NAME
, NULL FORMULA_DESCRIPTION
, TCC.CREATED_BY
, TCC.CREATION_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS LK
, HXC_MAPPING_COMPONENTS_V MPC
, FND_FLEX_VALUE_SETS FFVS
, HXC_TIME_CATEGORY_COMPS TCC
WHERE TCC.TYPE = 'MC_VS'
AND MPC.MAPPING_COMPONENT_ID = TCC.COMPONENT_TYPE_ID
AND FFVS.FLEX_VALUE_SET_ID = TCC.FLEX_VALUE_SET_ID
AND LK.LOOKUP_TYPE = 'HXC_TIME_CATEGORY_IS_NULL'
AND LK.LOOKUP_CODE = TCC.IS_NULL UNION SELECT TCC.ROWID ROW_ID
, TCC.TIME_CATEGORY_COMP_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TIME_CATEGORY_ID
, TCC.REF_TIME_CATEGORY_ID
, NULL TIME_CATEGORY_NAME
, NULL TIME_CATEGORY_DESCRIPTION
, NULL REF_OPERATOR
, TCC.TYPE
, TCC.COMPONENT_TYPE_ID
, TCC.FLEX_VALUE_SET_ID
, TCC.EQUAL_TO
, TCC.IS_NULL
, LK.MEANING IS_NULL_MEANING
, TCC.VALUE_ID
, NULL VALUE
, NULL SEGMENT
, NULL CONTEXT
, NULL CATEGORY
, NULL END_USER_COLUMN_NAME
, NULL MAPPING_COMPONENT_NAME
, LK1.LOOKUP_CODE AN_CONTEXT
, LK1.MEANING AN_CONTEXT_MEANING
, HAV.ALIAS_VALUE_NAME
, NULL VALUE_SET_NAME
, NULL FORMULA_NAME
, NULL FORMULA_DESCRIPTION
, TCC.CREATED_BY
, TCC.CREATION_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS LK
, HR_LOOKUPS LK1
, HXC_ALIAS_VALUES HAV
, HXC_TIME_CATEGORY_COMPS TCC
WHERE TCC.TYPE = 'AN'
AND HAV.ALIAS_VALUE_ID = TCC.COMPONENT_TYPE_ID
AND LK1.LOOKUP_TYPE = 'HXC_TIME_CATEGORY_ALT_NAME'
AND EXISTS ( SELECT 'X' FROM HXC_BLD_BLK_INFO_TYPES BBIT
, HXC_MAPPING_COMPONENTS MPC
, HXC_ALIAS_TYPE_COMPONENTS ATC
, HXC_ALIAS_TYPES AT
, HXC_ALIAS_DEFINITIONS AD WHERE AD.ALIAS_DEFINITION_ID = HAV.ALIAS_DEFINITION_ID
AND AT.ALIAS_TYPE_ID = AD.ALIAS_TYPE_ID AND ATC.ALIAS_TYPE_ID = AT.ALIAS_TYPE_ID AND MPC.MAPPING_COMPONENT_ID = ATC.MAPPING_COMPONENT_ID AND BBIT.BLD_BLK_INFO_TYPE_ID = MPC.BLD_BLK_INFO_TYPE_ID AND BBIT.BLD_BLK_INFO_TYPE = DECODE ( LK1.LOOKUP_CODE
, 'PROJECTS'
, 'PROJECTS'
, 'COST'
, 'DUMMY COST CONTEXT'
, 'GRP'
, 'DUMMY GRP CONTEXT'
, 'JOB'
, 'DUMMY JOB CONTEXT'
, 'POS'
, 'DUMMY POS CONTEXT'
, 'NOTHING') )
AND LK.LOOKUP_TYPE = 'HXC_TIME_CATEGORY_IS_NULL'
AND LK.LOOKUP_CODE = TCC.IS_NULL UNION SELECT TCC.ROWID ROW_ID
, TCC.TIME_CATEGORY_COMP_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TIME_CATEGORY_ID
, TCC.REF_TIME_CATEGORY_ID
, HTC.TIME_CATEGORY_NAME
, HTC.DESCRIPTION TIME_CATEGORY_DESCRIPTION
, HTC.OPERATOR REF_OPERATOR
, TCC.TYPE
, TCC.COMPONENT_TYPE_ID
, TCC.FLEX_VALUE_SET_ID
, TCC.EQUAL_TO
, TCC.IS_NULL
, NULL IS_NULL_MEANING
, TCC.VALUE_ID
, NULL VALUE
, NULL SEGMENT
, NULL CONTEXT
, NULL CATEGORY
, NULL END_USER_COLUMN_NAME
, NULL MAPPING_COMPONENT_NAME
, NULL AN_CONTEXT
, NULL AN_CONTEXT_MEANING
, NULL ALIAS_VALUE_NAME
, NULL VALUE_SET_NAME
, NULL FORMULA_NAME
, NULL FORMULA_DESCRIPTION
, TCC.CREATED_BY
, TCC.CREATION_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATE_LOGIN
FROM HXC_TIME_CATEGORIES HTC
, HXC_TIME_CATEGORY_COMPS TCC
WHERE TCC.TYPE = 'TC'
AND HTC.TIME_CATEGORY_ID = TCC.REF_TIME_CATEGORY_ID UNION SELECT TCC.ROWID ROW_ID
, TCC.TIME_CATEGORY_COMP_ID
, TCC.OBJECT_VERSION_NUMBER
, TCC.TIME_CATEGORY_ID
, TCC.REF_TIME_CATEGORY_ID
, NULL TIME_CATEGORY_NAME
, NULL TIME_CATEGORY_DESCRIPTION
, NULL REF_OPERATOR
, TCC.TYPE
, TCC.COMPONENT_TYPE_ID
, TCC.FLEX_VALUE_SET_ID
, TCC.EQUAL_TO
, TCC.IS_NULL
, NULL IS_NULL_MEANING
, TCC.VALUE_ID
, NULL VALUE
, NULL SEGMENT
, NULL CONTEXT
, NULL CATEGORY
, NULL END_USER_COLUMN_NAME
, NULL MAPPING_COMPONENT_NAME
, NULL AN_CONTEXT
, NULL AN_CONTEXT_MEANING
, NULL ALIAS_VALUE_NAME
, NULL VALUE_SET_NAME
, FF.FORMULA_NAME
, FF.DESCRIPTION FORMULA_DESCRIPTION
, TCC.CREATED_BY
, TCC.CREATION_DATE
, TCC.LAST_UPDATED_BY
, TCC.LAST_UPDATE_DATE
, TCC.LAST_UPDATE_LOGIN
FROM FND_SESSIONS F
, FF_FORMULAS_F FF
, HXC_TIME_CATEGORY_COMPS TCC
WHERE TCC.TYPE = 'FF'
AND FF.FORMULA_ID = TCC.COMPONENT_TYPE_ID
AND F.EFFECTIVE_DATE BETWEEN FF.EFFECTIVE_START_DATE
AND FF.EFFECTIVE_END_DATE
AND F.SESSION_ID = USERENV('SESSIONID')

Columns