View: BIS_GL_SECONDARY_MEASURES_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_GL_SECONDARY_MEASURES_V

View Text

SELECT FV.FLEX_VALUE ID
, FV.FLEX_VALUE VALUE
, FM.STRUCTURE_NUM CHART_OF_ACCOUNTS_ID
, FV.FLEX_VALUE FLEX_VALUE
, FV.DESCRIPTION DESCRIPTION
, TO_CHAR(SOB.SET_OF_BOOKS_ID) SET_OF_BOOKS_ID
FROM GL_SETS_OF_BOOKS SOB
, BIS_FLEX_MAPPINGS_V FM
, FND_FLEX_VALUES_VL FV
WHERE FM.STRUCTURE_NUM = SOB.CHART_OF_ACCOUNTS_ID
AND FM.LEVEL_SHORT_NAME = 'GL SECONDARY MEASURE'
AND FM.APPLICATION_ID = 101
AND FM.ID_FLEX_CODE = 'GL#'
AND FV.FLEX_VALUE_SET_ID = FM.VALUE_SET_ID
AND FV.ENABLED_FLAG = 'Y'
AND FV.SUMMARY_FLAG = 'N'
AND TRUNC(SYSDATE) BETWEEN NVL(FV.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(FV.END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns