VIEW: APPS.XLA_DESCRIPT_DETAILS_FVL

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.description_detail_id description_detail_id ,b.description_prio_id description_prio_id ,b.amb_context_code amb_context_code ,b.user_sequence user_sequence ,b.value_type_code value_type_code ,b.source_application_id source_application_id ,b.source_type_code source_type_code ,b.source_code source_code ,b.display_description_flag display_description_flag ,stl.flexfield_application_id source_flex_appl_id ,stl.id_flex_code source_id_flex_code ,stl.segment_code source_segment_code ,stl.name source_name ,stl.datatype_code source_datatype_code ,tl.literal literal ,b.flexfield_segment_code flexfield_segment_code ,b.creation_date creation_date ,b.created_by created_by ,b.last_update_date last_update_date ,b.last_update_login last_update_login ,b.last_updated_by last_updated_by FROM xla_sources_vl stl ,xla_descript_details_b b ,xla_descript_details_tl tl WHERE b.description_detail_id = tl.description_detail_id AND tl.language = USERENV('LANG') AND b.source_application_id = stl.application_id(+) AND b.source_type_code = stl.source_type_code(+) AND b.source_code = stl.source_code(+)

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.DESCRIPTION_DETAIL_ID DESCRIPTION_DETAIL_ID
, B.DESCRIPTION_PRIO_ID DESCRIPTION_PRIO_ID
, B.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, B.USER_SEQUENCE USER_SEQUENCE
, B.VALUE_TYPE_CODE VALUE_TYPE_CODE
, B.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, B.DISPLAY_DESCRIPTION_FLAG DISPLAY_DESCRIPTION_FLAG
, STL.FLEXFIELD_APPLICATION_ID SOURCE_FLEX_APPL_ID
, STL.ID_FLEX_CODE SOURCE_ID_FLEX_CODE
, STL.SEGMENT_CODE SOURCE_SEGMENT_CODE
, STL.NAME SOURCE_NAME
, STL.DATATYPE_CODE SOURCE_DATATYPE_CODE
, TL.LITERAL LITERAL
, B.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_SOURCES_VL STL
, XLA_DESCRIPT_DETAILS_B B
, XLA_DESCRIPT_DETAILS_TL TL
WHERE B.DESCRIPTION_DETAIL_ID = TL.DESCRIPTION_DETAIL_ID
AND TL.LANGUAGE = USERENV('LANG')
AND B.SOURCE_APPLICATION_ID = STL.APPLICATION_ID(+)
AND B.SOURCE_TYPE_CODE = STL.SOURCE_TYPE_CODE(+)
AND B.SOURCE_CODE = STL.SOURCE_CODE(+)