View: FND_FLEX_VALUE_CHILDREN_V

Product:	FND - Application Object Library
Description:	View of FND_FLEX_VALUES_VL, FND_FLEX_VALUE_NORM_HIERARCHY and FND_FLEX_VALUE_SETS
Implementation/DBA Data:	APPS.FND_FLEX_VALUE_CHILDREN_V

View Text

SELECT V.FLEX_VALUE_SET_ID
, H.PARENT_FLEX_VALUE
, V.FLEX_VALUE
, V.DESCRIPTION
, V.SUMMARY_FLAG
FROM FND_FLEX_VALUES_VL V
, FND_FLEX_VALUE_NORM_HIERARCHY H
, FND_FLEX_VALUE_SETS S
WHERE H.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
AND S.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
AND ( ((S.FORMAT_TYPE = 'N')
AND ( FND_NUMBER.CANONICAL_TO_NUMBER(V.FLEX_VALUE) BETWEEN FND_NUMBER.CANONICAL_TO_NUMBER(H.CHILD_FLEX_VALUE_LOW)
AND FND_NUMBER.CANONICAL_TO_NUMBER(H.CHILD_FLEX_VALUE_HIGH))) OR ((S.FORMAT_TYPE IN ('D'
, 'T'))
AND (TO_DATE(V.FLEX_VALUE
, (DECODE(S.MAXIMUM_SIZE
, 5
, 'HH24:MI'
, 8
, 'HH24:MI:SS'
, 9
, 'DD-MON-RR'
, 11
, 'DD-MON-YYYY'
, 15
, 'DD-MON-RR HH24:MI'
, 17
, 'DD-MON-YYYY HH24:MI'
, 18
, 'DD-MON-RR HH24:MI:SS'
, 20
, 'DD-MON-YYYY HH24:MI:SS'))) BETWEEN TO_DATE(H.CHILD_FLEX_VALUE_LOW
, (DECODE(S.MAXIMUM_SIZE
, 5
, 'HH24:MI'
, 8
, 'HH24:MI:SS'
, 9
, 'DD-MON-RR'
, 11
, 'DD-MON-YYYY'
, 15
, 'DD-MON-RR HH24:MI'
, 17
, 'DD-MON-YYYY HH24:MI'
, 18
, 'DD-MON-RR HH24:MI:SS'
, 20
, 'DD-MON-YYYY HH24:MI:SS')))
AND TO_DATE(H.CHILD_FLEX_VALUE_HIGH
, (DECODE(S.MAXIMUM_SIZE
, 5
, 'HH24:MI'
, 8
, 'HH24:MI:SS'
, 9
, 'DD-MON-RR'
, 11
, 'DD-MON-YYYY'
, 15
, 'DD-MON-RR HH24:MI'
, 17
, 'DD-MON-YYYY HH24:MI'
, 18
, 'DD-MON-RR HH24:MI:SS'
, 20
, 'DD-MON-YYYY HH24:MI:SS'))))) OR ((S.FORMAT_TYPE NOT IN ('N'
, 'D'
, 'T'))
AND (V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW
AND H.CHILD_FLEX_VALUE_HIGH)))
AND ( (V.SUMMARY_FLAG = 'Y'
AND H.RANGE_ATTRIBUTE = 'P') OR (V.SUMMARY_FLAG = 'N'
AND H.RANGE_ATTRIBUTE = 'C'))

Columns