VIEW: APPS.JTM_H_DESCRIPTIVE_FLEXS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, SEED.MOBILE_TABLE_NAME, B.APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_NAME, B.LAST_UPDATE_DATE, B.CREATION_DATE, B.CONTEXT_REQUIRED_FLAG, B.CONTEXT_COLUMN_NAME, B.DEFAULT_CONTEXT_VALUE, TL.FORM_CONTEXT_PROMPT, TL.TITLE FROM FND_DESCRIPTIVE_FLEXS B, FND_DESCRIPTIVE_FLEXS_TL TL, JTM_FND_DESCR_FLEXS_ACC SEED, JTM_H_FND_DESCRIP_FLEXS_ACC ACC WHERE B.APPLICATION_ID = TL.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND B.APPLICATION_ID = ACC.APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME AND B.APPLICATION_ID = SEED.BASE_APPLICATION_ID AND B.DESCRIPTIVE_FLEXFIELD_NAME = SEED.DESCRIPTIVE_FLEXFIELD_NAME AND SEED.APPLICATION_ID = 883

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, SEED.MOBILE_TABLE_NAME
, B.APPLICATION_ID
, B.DESCRIPTIVE_FLEXFIELD_NAME
, B.LAST_UPDATE_DATE
, B.CREATION_DATE
, B.CONTEXT_REQUIRED_FLAG
, B.CONTEXT_COLUMN_NAME
, B.DEFAULT_CONTEXT_VALUE
, TL.FORM_CONTEXT_PROMPT
, TL.TITLE
FROM FND_DESCRIPTIVE_FLEXS B
, FND_DESCRIPTIVE_FLEXS_TL TL
, JTM_FND_DESCR_FLEXS_ACC SEED
, JTM_H_FND_DESCRIP_FLEXS_ACC ACC
WHERE B.APPLICATION_ID = TL.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = TL.DESCRIPTIVE_FLEXFIELD_NAME
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND B.APPLICATION_ID = ACC.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = ACC.DESCRIPTIVE_FLEXFIELD_NAME
AND B.APPLICATION_ID = SEED.BASE_APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = SEED.DESCRIPTIVE_FLEXFIELD_NAME
AND SEED.APPLICATION_ID = 883