VIEW: APPS.FND_FLEX_KFF_SEG_VSET_V

Source

View Text - Preformatted

SELECT
  A.APPLICATION_ID
, A.APPLICATION_NAME
, K.ID_FLEX_NAME
, K.DESCRIPTION
, K.ID_FLEX_CODE
, S.ID_FLEX_STRUCTURE_NAME
, S.ID_FLEX_NUM
, S.DESCRIPTION
, SG.SEGMENT_NAME
, V.FLEX_VALUE_SET_ID
, V.PARENT_FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, V.VALIDATION_TYPE
, T.SUMMARY_ALLOWED_FLAG
FROM
  FND_ID_FLEXS K
, FND_APPLICATION_VL A
, FND_ID_FLEX_STRUCTURES_VL S
, FND_ID_FLEX_SEGMENTS SG
, FND_FLEX_VALUE_SETS V
, 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.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
, K.ID_FLEX_CODE
, S.ID_FLEX_STRUCTURE_NAME
, S.ID_FLEX_NUM
, S.DESCRIPTION
, SG.SEGMENT_NAME
, V.FLEX_VALUE_SET_ID
, V.PARENT_FLEX_VALUE_SET_ID
, V.SECURITY_ENABLED_FLAG
, V.VALIDATION_TYPE
, T.SUMMARY_ALLOWED_FLAG FROM FND_ID_FLEXS K
, FND_APPLICATION_VL A
, FND_ID_FLEX_STRUCTURES_VL S
, FND_ID_FLEX_SEGMENTS SG
, FND_FLEX_VALUE_SETS V
, 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.FLEX_VALUE_SET_ID = T.FLEX_VALUE_SET_ID(+)