VIEW: APPS.XLA_SUBLEDGERS_FVL

Source

View Text - Preformatted

SELECT x.rowid ,x.application_id ,x.application_type_code ,f.application_name ,x.je_source_name ,j.user_je_source_name ,x.valuation_method_flag ,x.drilldown_procedure_name ,decode(x.security_function_name, null, 'N','Y') ,x.security_function_name ,alc_enabled_flag ,control_account_type_code ,x.creation_date ,x.created_by ,x.last_update_date ,x.last_updated_by ,x.last_update_login FROM xla_subledgers x ,gl_je_sources_tl j ,fnd_application_vl f WHERE x.application_id = f.application_id AND j.je_source_name = x.je_source_name AND j.language = USERENV('LANG')

View Text - HTML Formatted

SELECT X.ROWID
, X.APPLICATION_ID
, X.APPLICATION_TYPE_CODE
, F.APPLICATION_NAME
, X.JE_SOURCE_NAME
, J.USER_JE_SOURCE_NAME
, X.VALUATION_METHOD_FLAG
, X.DRILLDOWN_PROCEDURE_NAME
, DECODE(X.SECURITY_FUNCTION_NAME
, NULL
, 'N'
, 'Y')
, X.SECURITY_FUNCTION_NAME
, ALC_ENABLED_FLAG
, CONTROL_ACCOUNT_TYPE_CODE
, X.CREATION_DATE
, X.CREATED_BY
, X.LAST_UPDATE_DATE
, X.LAST_UPDATED_BY
, X.LAST_UPDATE_LOGIN
FROM XLA_SUBLEDGERS X
, GL_JE_SOURCES_TL J
, FND_APPLICATION_VL F
WHERE X.APPLICATION_ID = F.APPLICATION_ID
AND J.JE_SOURCE_NAME = X.JE_SOURCE_NAME
AND J.LANGUAGE = USERENV('LANG')