View: XLA_SOURCES_AVAILABLE_XVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_SOURCES_AVAILABLE_XVL

View Text

SELECT B.ROWID ROW_ID
, S.APPLICATION_ID APPLICATION_ID
, B.APPLICATION_ID SOURCE_APPLICATION_ID
, A.APPLICATION_NAME SOURCE_APPLICATION_NAME
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.ENABLED_FLAG ENABLED_FLAG
, B.DATATYPE_CODE DATATYPE_CODE
, B.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VISIBLE_FLAG VISIBLE_FLAG
, B.SUM_FLAG SUM_FLAG
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SOURCES_TL T
, XLA_SOURCES_B B
, XLA_SUBLEDGERS S
, FND_APPLICATION_TL A
WHERE (B.APPLICATION_ID = S.APPLICATION_ID OR B.APPLICATION_ID = 602)
AND B.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = A.APPLICATION_ID
AND A.LANGUAGE = USERENV('LANG')
AND B.SOURCE_TYPE_CODE = T.SOURCE_TYPE_CODE
AND B.SOURCE_CODE = T.SOURCE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.ENABLED_FLAG = 'Y'
AND B.VISIBLE_FLAG = 'Y' UNION SELECT B.ROWID ROW_ID
, R.APPLICATION_ID APPLICATION_ID
, R.REFERENCE_OBJECT_APPL_ID SOURCE_APPLICATION_ID
, A.APPLICATION_NAME SOURCE_APPLICATION_NAME
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.ENABLED_FLAG ENABLED_FLAG
, B.DATATYPE_CODE DATATYPE_CODE
, B.PLSQL_FUNCTION_NAME PLSQL_FUNCTION_NAME
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VISIBLE_FLAG VISIBLE_FLAG
, B.SUM_FLAG SUM_FLAG
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_SOURCES_TL T
, XLA_SOURCES_B B
, FND_APPLICATION_TL A
, (SELECT DISTINCT APPLICATION_ID
, REFERENCE_OBJECT_APPL_ID
FROM XLA_REFERENCE_OBJECTS) R
WHERE B.APPLICATION_ID = R.REFERENCE_OBJECT_APPL_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = A.APPLICATION_ID
AND A.LANGUAGE = USERENV('LANG')
AND B.SOURCE_TYPE_CODE = T.SOURCE_TYPE_CODE
AND B.SOURCE_CODE = T.SOURCE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.ENABLED_FLAG = 'Y'
AND B.VISIBLE_FLAG = 'Y'

Columns