View: XLA_DESCRIPT_DETAILS_FVL

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

View Text

SELECT B.ROWID ROW_ID
, B.DESCRIPTION_DETAIL_ID DESCRIPTION_DETAIL_ID
, B.DESCRIPTION_PRIO_ID DESCRIPTION_PRIO_ID
, B.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, B.USER_SEQUENCE USER_SEQUENCE
, B.VALUE_TYPE_CODE VALUE_TYPE_CODE
, B.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.SOURCE_CODE SOURCE_CODE
, B.DISPLAY_DESCRIPTION_FLAG DISPLAY_DESCRIPTION_FLAG
, STL.FLEXFIELD_APPLICATION_ID SOURCE_FLEX_APPL_ID
, STL.ID_FLEX_CODE SOURCE_ID_FLEX_CODE
, STL.SEGMENT_CODE SOURCE_SEGMENT_CODE
, STL.NAME SOURCE_NAME
, STL.DATATYPE_CODE SOURCE_DATATYPE_CODE
, TL.LITERAL LITERAL
, B.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_SOURCES_VL STL
, XLA_DESCRIPT_DETAILS_B B
, XLA_DESCRIPT_DETAILS_TL TL
WHERE B.DESCRIPTION_DETAIL_ID = TL.DESCRIPTION_DETAIL_ID
AND TL.LANGUAGE = USERENV('LANG')
AND B.SOURCE_APPLICATION_ID = STL.APPLICATION_ID(+)
AND B.SOURCE_TYPE_CODE = STL.SOURCE_TYPE_CODE(+)
AND B.SOURCE_CODE = STL.SOURCE_CODE(+)

Columns