VIEW: APPS.JTM_FND_FLEX_VALUES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, A.FLEX_VALUE_SET_ID, A.FLEX_VALUE_ID, A.FLEX_VALUE, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.ENABLED_FLAG, A.SUMMARY_FLAG, A.START_DATE_ACTIVE, A.END_DATE_ACTIVE, A.PARENT_FLEX_VALUE_LOW, A.PARENT_FLEX_VALUE_HIGH, A.STRUCTURED_HIERARCHY_LEVEL, A.HIERARCHY_LEVEL, A.COMPILED_VALUE_ATTRIBUTES, A.VALUE_CATEGORY, A.ATTRIBUTE1, A.ATTRIBUTE2, A.ATTRIBUTE3, A.ATTRIBUTE4, A.ATTRIBUTE5, A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10, A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15, A.ATTRIBUTE16, A.ATTRIBUTE17, A.ATTRIBUTE18, A.ATTRIBUTE19, A.ATTRIBUTE20, A.ATTRIBUTE21, A.ATTRIBUTE22, A.ATTRIBUTE23, A.ATTRIBUTE24, A.ATTRIBUTE25, A.ATTRIBUTE26, A.ATTRIBUTE27, A.ATTRIBUTE28, A.ATTRIBUTE29, A.ATTRIBUTE30, A.ATTRIBUTE31, A.ATTRIBUTE32, A.ATTRIBUTE33, A.ATTRIBUTE34, A.ATTRIBUTE35, A.ATTRIBUTE36, A.ATTRIBUTE37, A.ATTRIBUTE38, A.ATTRIBUTE39, A.ATTRIBUTE40, A.ATTRIBUTE41, A.ATTRIBUTE42, A.ATTRIBUTE43, A.ATTRIBUTE44, A.ATTRIBUTE45, A.ATTRIBUTE46, A.ATTRIBUTE47, A.ATTRIBUTE48, A.ATTRIBUTE49, A.ATTRIBUTE50, T.DESCRIPTION FROM FND_FLEX_VALUES A, FND_FLEX_VALUES_TL T, JTM_FND_FLEX_VALUES_ACC ACC WHERE A.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE AND A.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID AND A.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 = 868 )

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, A.FLEX_VALUE_SET_ID
, A.FLEX_VALUE_ID
, A.FLEX_VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ENABLED_FLAG
, A.SUMMARY_FLAG
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.PARENT_FLEX_VALUE_LOW
, A.PARENT_FLEX_VALUE_HIGH
, A.STRUCTURED_HIERARCHY_LEVEL
, A.HIERARCHY_LEVEL
, A.COMPILED_VALUE_ATTRIBUTES
, A.VALUE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.ATTRIBUTE21
, A.ATTRIBUTE22
, A.ATTRIBUTE23
, A.ATTRIBUTE24
, A.ATTRIBUTE25
, A.ATTRIBUTE26
, A.ATTRIBUTE27
, A.ATTRIBUTE28
, A.ATTRIBUTE29
, A.ATTRIBUTE30
, A.ATTRIBUTE31
, A.ATTRIBUTE32
, A.ATTRIBUTE33
, A.ATTRIBUTE34
, A.ATTRIBUTE35
, A.ATTRIBUTE36
, A.ATTRIBUTE37
, A.ATTRIBUTE38
, A.ATTRIBUTE39
, A.ATTRIBUTE40
, A.ATTRIBUTE41
, A.ATTRIBUTE42
, A.ATTRIBUTE43
, A.ATTRIBUTE44
, A.ATTRIBUTE45
, A.ATTRIBUTE46
, A.ATTRIBUTE47
, A.ATTRIBUTE48
, A.ATTRIBUTE49
, A.ATTRIBUTE50
, T.DESCRIPTION
FROM FND_FLEX_VALUES A
, FND_FLEX_VALUES_TL T
, JTM_FND_FLEX_VALUES_ACC ACC
WHERE A.FLEX_VALUE_ID = T.FLEX_VALUE_ID
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND A.FLEX_VALUE_ID = ACC.FLEX_VALUE_ID
AND A.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 = 868 )