VIEW: APPS.JTM_FND_DESC_FLX_CONTEXT_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_NAME, B.DESCRIPTIVE_FLEX_CONTEXT_CODE, TL.DESCRIPTIVE_FLEX_CONTEXT_NAME, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.ENABLED_FLAG, B.GLOBAL_FLAG FROM FND_DESCR_FLEX_CONTEXTS B ,FND_DESCR_FLEX_CONTEXTS_TL TL ,JTM_FND_DESC_FLEX_CONTEXT_ACC ACC ,JTM_FND_DESCR_FLEXS_ACC ACC_BASE WHERE ACC_BASE.APPLICATION_ID = 868 AND ACC_BASE.BASE_APPLICATION_ID = ACC.APPLICATION_ID AND ACC_BASE.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME AND B.APPLICATION_ID = ACC.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME AND B.DESCRIPTIVE_FLEX_CONTEXT_CODE = ACC.DESCRIPTIVE_FLEX_CONTEXT_CODE AND TL.APPLICATION_ID = B.APPLICATION_ID AND TL.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME AND TL.DESCRIPTIVE_FLEX_CONTEXT_CODE = B.DESCRIPTIVE_FLEX_CONTEXT_CODE AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.APPLICATION_ID
, B.DESCRIPTIVE_FLEXFIELD_NAME
, B.DESCRIPTIVE_FLEX_CONTEXT_CODE
, TL.DESCRIPTIVE_FLEX_CONTEXT_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ENABLED_FLAG
, B.GLOBAL_FLAG
FROM FND_DESCR_FLEX_CONTEXTS B
, FND_DESCR_FLEX_CONTEXTS_TL TL
, JTM_FND_DESC_FLEX_CONTEXT_ACC ACC
, JTM_FND_DESCR_FLEXS_ACC ACC_BASE
WHERE ACC_BASE.APPLICATION_ID = 868
AND ACC_BASE.BASE_APPLICATION_ID = ACC.APPLICATION_ID
AND ACC_BASE.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME
AND B.APPLICATION_ID = ACC.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME
AND B.DESCRIPTIVE_FLEX_CONTEXT_CODE = ACC.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND TL.APPLICATION_ID = B.APPLICATION_ID
AND TL.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
AND TL.DESCRIPTIVE_FLEX_CONTEXT_CODE = B.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE