VIEW: APPS.XLA_SOURCES_AVAILABLE_XVL

Source

View Text - Preformatted

SELECT b.rowid row_id ,s.application_id application_id ,b.application_id source_application_id ,a.application_name source_application_name ,b.source_type_code source_type_code ,b.source_code source_code ,t.name name ,t.description description ,b.enabled_flag enabled_flag ,b.datatype_code datatype_code ,b.plsql_function_name plsql_function_name ,b.flex_value_set_id flex_value_set_id ,b.visible_flag visible_flag ,b.sum_flag sum_flag ,b.translated_flag translated_flag ,b.view_application_id view_application_id ,b.lookup_type lookup_type ,b.key_flexfield_flag key_flexfield_flag ,b.segment_code segment_code ,b.flexfield_application_id flexfield_application_id ,b.id_flex_code id_flex_code ,b.creation_date creation_date ,b.created_by created_by ,b.last_update_date last_update_date ,b.last_updated_by last_updated_by ,b.last_update_login last_update_login FROM xla_sources_tl t ,xla_sources_b b ,xla_subledgers s ,fnd_application_tl a WHERE (b.application_id = s.application_id OR b.application_id = 602) AND b.application_id = t.application_id AND b.application_id = a.application_id AND a.LANGUAGE = userenv('LANG') AND b.source_type_code = t.source_type_code AND b.source_code = t.source_code AND t.language = USERENV('LANG') AND b.enabled_flag = 'Y' AND b.visible_flag = 'Y' UNION SELECT b.rowid row_id ,r.application_id application_id ,r.reference_object_appl_id source_application_id ,a.application_name source_application_name ,b.source_type_code source_type_code ,b.source_code source_code ,t.name name ,t.description description ,b.enabled_flag enabled_flag ,b.datatype_code datatype_code ,b.plsql_function_name plsql_function_name ,b.flex_value_set_id flex_value_set_id ,b.visible_flag visible_flag ,b.sum_flag sum_flag ,b.translated_flag translated_flag ,b.view_application_id view_application_id ,b.lookup_type lookup_type ,b.key_flexfield_flag key_flexfield_flag ,b.segment_code segment_code ,b.flexfield_application_id flexfield_application_id ,b.id_flex_code id_flex_code ,b.creation_date creation_date ,b.created_by created_by ,b.last_update_date last_update_date ,b.last_updated_by last_updated_by ,b.last_update_login last_update_login FROM xla_sources_tl t ,xla_sources_b b ,fnd_application_tl a , (SELECT DISTINCT application_id, reference_object_appl_id FROM xla_reference_objects) r WHERE b.application_id = r.reference_object_appl_id AND b.application_id = t.application_id AND b.application_id = a.application_id AND a.LANGUAGE = userenv('LANG') AND b.source_type_code = t.source_type_code AND b.source_code = t.source_code AND t.language = USERENV('LANG') AND b.enabled_flag = 'Y' AND b.visible_flag = 'Y'

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, S.APPLICATION_ID APPLICATION_ID
, B.APPLICATION_ID SOURCE_APPLICATION_ID
, A.APPLICATION_NAME SOURCE_APPLICATION_NAME
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.ENABLED_FLAG ENABLED_FLAG
, B.DATATYPE_CODE DATATYPE_CODE
, B.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VISIBLE_FLAG VISIBLE_FLAG
, B.SUM_FLAG SUM_FLAG
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SOURCES_TL T
, XLA_SOURCES_B B
, XLA_SUBLEDGERS S
, FND_APPLICATION_TL A
WHERE (B.APPLICATION_ID = S.APPLICATION_ID OR B.APPLICATION_ID = 602)
AND B.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = A.APPLICATION_ID
AND A.LANGUAGE = USERENV('LANG')
AND B.SOURCE_TYPE_CODE = T.SOURCE_TYPE_CODE
AND B.SOURCE_CODE = T.SOURCE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.ENABLED_FLAG = 'Y'
AND B.VISIBLE_FLAG = 'Y' UNION SELECT B.ROWID ROW_ID
, R.APPLICATION_ID APPLICATION_ID
, R.REFERENCE_OBJECT_APPL_ID SOURCE_APPLICATION_ID
, A.APPLICATION_NAME SOURCE_APPLICATION_NAME
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.ENABLED_FLAG ENABLED_FLAG
, B.DATATYPE_CODE DATATYPE_CODE
, B.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VISIBLE_FLAG VISIBLE_FLAG
, B.SUM_FLAG SUM_FLAG
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SOURCES_TL T
, XLA_SOURCES_B B
, FND_APPLICATION_TL A
, (SELECT DISTINCT APPLICATION_ID
, REFERENCE_OBJECT_APPL_ID
FROM XLA_REFERENCE_OBJECTS) R
WHERE B.APPLICATION_ID = R.REFERENCE_OBJECT_APPL_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = A.APPLICATION_ID
AND A.LANGUAGE = USERENV('LANG')
AND B.SOURCE_TYPE_CODE = T.SOURCE_TYPE_CODE
AND B.SOURCE_CODE = T.SOURCE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.ENABLED_FLAG = 'Y'
AND B.VISIBLE_FLAG = 'Y'