VIEW: APPS.JTM_H_FLEX_VALUES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, VAL.FLEX_VALUE_SET_ID, VAL.FLEX_VALUE_ID, VAL.FLEX_VALUE, VAL.PARENT_FLEX_VALUE_LOW, VAL.PARENT_FLEX_VALUE_HIGH FROM FND_FLEX_VALUES VAL, JTM_FND_FLEX_VALUES_ACC ACC WHERE VAL.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID AND VAL.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID FROM FND_DESCR_FLEX_COLUMN_USAGES BAS, JTM_FND_DESCR_FLEXS_ACC ACC WHERE BAS.APPLICATION_ID = ACC.BASE_APPLICATION_ID AND BAS.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME AND ACC.APPLICATION_ID = 883 )

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, VAL.FLEX_VALUE_SET_ID
, VAL.FLEX_VALUE_ID
, VAL.FLEX_VALUE
, VAL.PARENT_FLEX_VALUE_LOW
, VAL.PARENT_FLEX_VALUE_HIGH
FROM FND_FLEX_VALUES VAL
, JTM_FND_FLEX_VALUES_ACC ACC
WHERE VAL.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID
AND VAL.FLEX_VALUE_SET_ID IN (SELECT FLEX_VALUE_SET_ID
FROM FND_DESCR_FLEX_COLUMN_USAGES BAS
, JTM_FND_DESCR_FLEXS_ACC ACC
WHERE BAS.APPLICATION_ID = ACC.BASE_APPLICATION_ID
AND BAS.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME
AND ACC.APPLICATION_ID = 883 )