VIEW: APPS.FND_FLEX_KEY_SEG_VSET_V

Source

View Text - Preformatted

SELECT A.APPLICATION_ID, A.APPLICATION_NAME, K.ID_FLEX_NAME, K.DESCRIPTION, S.ID_FLEX_STRUCTURE_NAME, S.DESCRIPTION, decode(V.PARENT_FLEX_VALUE_SET_ID, null, null,SG.SEGMENT_NAME), SG.DESCRIPTION, decode(V.PARENT_FLEX_VALUE_SET_ID, null,SG.SEGMENT_NAME, SG2.SEGMENT_NAME), V.FLEX_VALUE_SET_ID, V.SECURITY_ENABLED_FLAG, V.PARENT_FLEX_VALUE_SET_ID, V.VALIDATION_TYPE, FV.FLEX_VALUE, FVT.DESCRIPTION, T.SUMMARY_ALLOWED_FLAG FROM FND_ID_FLEXS K, FND_APPLICATION_VL A, FND_ID_FLEX_STRUCTURES_VL S, FND_ID_FLEX_SEGMENTS_VL SG, FND_FLEX_VALUE_SETS V, FND_ID_FLEX_SEGMENTS SG2, FND_FLEX_VALUES FV, FND_FLEX_VALUES_TL FVT, FND_FLEX_VALIDATION_TABLES T WHERE K.APPLICATION_ID = A.APPLICATION_ID AND K.APPLICATION_ID = S.APPLICATION_ID AND K.ID_FLEX_CODE = S.ID_FLEX_CODE AND S.ENABLED_FLAG = 'Y' AND K.APPLICATION_ID = SG.APPLICATION_ID AND K.ID_FLEX_CODE = SG.ID_FLEX_CODE AND S.ID_FLEX_NUM = SG.ID_FLEX_NUM AND SG.ENABLED_FLAG = 'Y' AND SG.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID AND V.PARENT_FLEX_VALUE_SET_ID = SG2.FLEX_VALUE_SET_ID(+) AND K.APPLICATION_ID = nvl(SG2.APPLICATION_ID, K.application_id) AND K.ID_FLEX_CODE = nvl(SG2.ID_FLEX_CODE, K.id_flex_code) AND S.ID_FLEX_NUM = nvl(SG2.ID_FLEX_NUM, s.id_flex_num) AND nvl(SG2.ENABLED_FLAG, 'Y') = 'Y' AND nvl(SG2.SEGMENT_NUM,0) = (select nvl(max(sg3.segment_num),0) from fnd_id_flex_segments sg3 where sg3.application_id = k.application_id and sg3.id_flex_code = k.id_flex_code and sg3.id_flex_num = s.id_flex_num and sg3.flex_value_set_id = v.parent_flex_value_set_id and sg3.segment_num < SG.SEGMENT_NUM and sg3.enabled_flag = 'Y') AND V.PARENT_FLEX_VALUE_SET_ID = FV.FLEX_VALUE_SET_ID(+) AND FV.FLEX_VALUE_ID = FVT.FLEX_VALUE_ID (+) AND FVT.LANGUAGE (+) = userenv('LANG') AND nvl(FV.ENABLED_FLAG, 'Y') = 'Y' AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)

View Text - HTML Formatted

SELECT A.APPLICATION_ID
, A.APPLICATION_NAME
, K.ID_FLEX_NAME
, K.DESCRIPTION
, S.ID_FLEX_STRUCTURE_NAME
, S.DESCRIPTION
, DECODE(V.PARENT_FLEX_VALUE_SET_ID
, NULL
, NULL
, SG.SEGMENT_NAME)
, SG.DESCRIPTION
, DECODE(V.PARENT_FLEX_VALUE_SET_ID
, NULL
, SG.SEGMENT_NAME
, SG2.SEGMENT_NAME)
, V.FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, V.PARENT_FLEX_VALUE_SET_ID
, V.VALIDATION_TYPE
, FV.FLEX_VALUE
, FVT.DESCRIPTION
, T.SUMMARY_ALLOWED_FLAG
FROM FND_ID_FLEXS K
, FND_APPLICATION_VL A
, FND_ID_FLEX_STRUCTURES_VL S
, FND_ID_FLEX_SEGMENTS_VL SG
, FND_FLEX_VALUE_SETS V
, FND_ID_FLEX_SEGMENTS SG2
, FND_FLEX_VALUES FV
, FND_FLEX_VALUES_TL FVT
, FND_FLEX_VALIDATION_TABLES T
WHERE K.APPLICATION_ID = A.APPLICATION_ID
AND K.APPLICATION_ID = S.APPLICATION_ID
AND K.ID_FLEX_CODE = S.ID_FLEX_CODE
AND S.ENABLED_FLAG = 'Y'
AND K.APPLICATION_ID = SG.APPLICATION_ID
AND K.ID_FLEX_CODE = SG.ID_FLEX_CODE
AND S.ID_FLEX_NUM = SG.ID_FLEX_NUM
AND SG.ENABLED_FLAG = 'Y'
AND SG.FLEX_VALUE_SET_ID = V.FLEX_VALUE_SET_ID
AND V.PARENT_FLEX_VALUE_SET_ID = SG2.FLEX_VALUE_SET_ID(+)
AND K.APPLICATION_ID = NVL(SG2.APPLICATION_ID
, K.APPLICATION_ID)
AND K.ID_FLEX_CODE = NVL(SG2.ID_FLEX_CODE
, K.ID_FLEX_CODE)
AND S.ID_FLEX_NUM = NVL(SG2.ID_FLEX_NUM
, S.ID_FLEX_NUM)
AND NVL(SG2.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(SG2.SEGMENT_NUM
, 0) = (SELECT NVL(MAX(SG3.SEGMENT_NUM)
, 0)
FROM FND_ID_FLEX_SEGMENTS SG3
WHERE SG3.APPLICATION_ID = K.APPLICATION_ID
AND SG3.ID_FLEX_CODE = K.ID_FLEX_CODE
AND SG3.ID_FLEX_NUM = S.ID_FLEX_NUM
AND SG3.FLEX_VALUE_SET_ID = V.PARENT_FLEX_VALUE_SET_ID
AND SG3.SEGMENT_NUM < SG.SEGMENT_NUM
AND SG3.ENABLED_FLAG = 'Y')
AND V.PARENT_FLEX_VALUE_SET_ID = FV.FLEX_VALUE_SET_ID(+)
AND FV.FLEX_VALUE_ID = FVT.FLEX_VALUE_ID (+)
AND FVT.LANGUAGE (+) = USERENV('LANG')
AND NVL(FV.ENABLED_FLAG
, 'Y') = 'Y'
AND V.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)