EGP_ITEM_AUD_SEG_VL

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
ATTR_TYPE GROUP_CODE GROUP_NAME ATTRIBUTE_CODE ATTRIBUTE_NAME LANGUAGE

Query

SQL_Statement

SELECT 'SEEDED' attr_type, attr_group_name group_code, attr_group_disp_name group_name, attr_name attribute_code, attr_disp_name attribute_name, language FROM egp_item_attributes_tl UNION ALL SELECT contexts.descriptive_flexfield_code attr_type, contexts.context_code group_code, contexts.name group_name, segments.segment_code attribute_code, segments.prompt attribute_name, segments.language FROM fnd_df_contexts_tl contexts, fnd_df_segments_tl segments WHERE segments.application_id = 10010 AND segments.application_id = contexts.application_id AND contexts.context_code = segments.context_code AND contexts.descriptive_flexfield_code = segments.descriptive_flexfield_code AND contexts.language = segments.language AND contexts.descriptive_flexfield_code IN ('EGO_ITEM_EFF') UNION ALL SELECT contexts.descriptive_flexfield_code attr_type, contexts.context_code group_code, contexts.name group_name, segments.segment_code attribute_code, segments.prompt attribute_name, segments.language FROM fnd_df_contexts_tl contexts, fnd_df_segments_tl segments WHERE segments.application_id = 10011 AND segments.application_id = contexts.application_id AND contexts.context_code = segments.context_code AND contexts.descriptive_flexfield_code = segments.descriptive_flexfield_code AND contexts.language = segments.language AND contexts.descriptive_flexfield_code IN ('EGP_SYSTEM_ITEMS_DFF', 'EGP_STRUCTURE_HEADER_DFF', 'EGP_COMPONENT_DFF') UNION ALL SELECT segments.descriptive_flexfield_code attr_type, lookups.lookup_code group_code, lookups.meaning group_name, segments.segment_code attribute_code, segments.prompt attribute_name, segments.language FROM fnd_df_segments_tl segments, fnd_df_flexfields_tl flex, fnd_lookups lookups WHERE segments.application_id = 10011 AND (segments.context_code = 'Global Data Elements' OR segments.context_code = 'Context Data Element') AND lookups.lookup_type = 'ORA_GLOBAL_DFF_ATTRS' AND lookups.lookup_code = 'ORA_GLOBAL_DFF_ATTRS' AND segments.descriptive_flexfield_code = flex.descriptive_flexfield_code AND segments.application_id = flex.application_id AND segments.LANGUAGE = flex.LANGUAGE AND segments.descriptive_flexfield_code IN ('EGP_SYSTEM_ITEMS_DFF', 'EGP_STRUCTURE_HEADER_DFF', 'EGP_COMPONENT_DFF')