VIEW: APPS.HXC_TIME_CATEGORY_COMPS_V

Source

View Text - Preformatted

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, fnd_lookup_values 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 AND lk.security_group_id = 0 AND lk.view_application_id = 3 AND lk.language = userenv('LANG') 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 fnd_lookup_values 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 AND lk.security_group_id = 0 AND lk.view_application_id = 3 AND lk.language = userenv('LANG') 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 fnd_lookup_values 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 AND lk.security_group_id = 0 AND lk.view_application_id = 3 AND lk.language = userenv('LANG') 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')

View Text - HTML Formatted

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
, FND_LOOKUP_VALUES 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
AND LK.SECURITY_GROUP_ID = 0
AND LK.VIEW_APPLICATION_ID = 3
AND LK.LANGUAGE = USERENV('LANG') 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 FND_LOOKUP_VALUES 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
AND LK.SECURITY_GROUP_ID = 0
AND LK.VIEW_APPLICATION_ID = 3
AND LK.LANGUAGE = USERENV('LANG') 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 FND_LOOKUP_VALUES 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
AND LK.SECURITY_GROUP_ID = 0
AND LK.VIEW_APPLICATION_ID = 3
AND LK.LANGUAGE = USERENV('LANG') 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')