DBA Data[Home] [Help]

VIEW: APPS.XLA_SOURCES_AVAILABLE_V

Source

View Text - Preformatted

SELECT s.application_id ,b.application_id source_application_id ,b.source_type_code ,b.source_code ,b.datatype_code ,b.plsql_function_name ,b.flex_value_set_id ,b.enabled_flag FROM xla_sources_b b ,xla_subledgers s WHERE (b.application_id = s.application_id OR b.application_id = 602)
View Text - HTML Formatted

SELECT S.APPLICATION_ID
, B.APPLICATION_ID SOURCE_APPLICATION_ID
, B.SOURCE_TYPE_CODE
, B.SOURCE_CODE
, B.DATATYPE_CODE
, B.PLSQL_FUNCTION_NAME
, B.FLEX_VALUE_SET_ID
, B.ENABLED_FLAG
FROM XLA_SOURCES_B B
, XLA_SUBLEDGERS S
WHERE (B.APPLICATION_ID = S.APPLICATION_ID OR B.APPLICATION_ID = 602)