VIEW: APPS.FND_FLEX_VALUE_CHILDREN_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))