FND Design Data [Home] [Help]

View: XLA_SUBLEDGERS_FVL

Product: XLA - Subledger Accounting
Description:
Implementation/DBA Data: ViewAPPS.XLA_SUBLEDGERS_FVL
View Text

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')

Columns

Name
ROW_ID
APPLICATION_ID
APPLICATION_TYPE_CODE
APPLICATION_NAME
JE_SOURCE_NAME
USER_JE_SOURCE_NAME
VALUATION_METHOD_FLAG
DRILLDOWN_PROCEDURE_NAME
USE_SECURITY_FUNCTION
SECURITY_FUNCTION_NAME
ALC_ENABLED_FLAG
CONTROL_ACCOUNT_TYPE_CODE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN