Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
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')