XLA_SUBLEDGERS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID JE_SOURCE_NAME VALUATION_METHOD_FLAG SECURITY_FUNCTION_NAME APPLICATION_TYPE_CODE ALC_ENABLED_FLAG CONTROL_ACCOUNT_TYPE_CODE DRILLDOWN_PROCEDURE_NAME REMOTE_URL ROW_LOCKING_FLAG OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN APPLICATION_SHORT_NAME ACCOUNTING_ENABLED PSFT_GL_FLAG IMPLEMENTATION_MODE_CODE APPLICATION_NAME DESCRIPTION ALLOW_REVERSALS_FLAG AUTO_DELETE_FLAG DEFAULT_CALC_SR_BALANCE_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID, B.JE_SOURCE_NAME, B.VALUATION_METHOD_FLAG, B.SECURITY_FUNCTION_NAME, B.APPLICATION_TYPE_CODE, B.ALC_ENABLED_FLAG, B.CONTROL_ACCOUNT_TYPE_CODE, B.DRILLDOWN_PROCEDURE_NAME, B.REMOTE_URL, B.ROW_LOCKING_FLAG, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.APPLICATION_SHORT_NAME, B.ACCOUNTING_ENABLED, B.PSFT_GL_FLAG, B.IMPLEMENTATION_MODE_CODE, T.APPLICATION_NAME, T.DESCRIPTION, B.ALLOW_REVERSALS_FLAG, B.AUTO_DELETE_FLAG, B.DEFAULT_CALC_SR_BALANCE_FLAG FROM XLA_SUBLEDGERS_TL T, XLA_SUBLEDGERS B WHERE B.APPLICATION_ID = T.APPLICATION_ID AND T.LANGUAGE = USERENV('LANG')