eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSM_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, B.CONTEXT_RUNTIME_PROPERTY_FUNCT, B.APPLICATION_TABLE_NAME, B.TABLE_APPLICATION_ID, B.CONTEXT_OVERRIDE_VALUE_SET_ID, B.CONTEXT_USER_OVERRIDE_FLAG, B.CONCATENATED_SEGMENT_DELIMITER, B.FREEZE_FLEX_DEFINITION_FLAG, B.PROTECTED_FLAG, B.DEFAULT_CONTEXT_FIELD_NAME, B.CONTEXT_DEFAULT_TYPE, B.CONTEXT_DEFAULT_VALUE, TL.DESCRIPTION FROM FND_DESCRIPTIVE_FLEXS B, FND_DESCRIPTIVE_FLEXS_TL TL, JTM_FND_DESCR_FLEXS_ACC SEED, CSM_DESCRIPTIVE_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
, B.CONTEXT_RUNTIME_PROPERTY_FUNCT
, B.APPLICATION_TABLE_NAME
, B.TABLE_APPLICATION_ID
, B.CONTEXT_OVERRIDE_VALUE_SET_ID
, B.CONTEXT_USER_OVERRIDE_FLAG
, B.CONCATENATED_SEGMENT_DELIMITER
, B.FREEZE_FLEX_DEFINITION_FLAG
, B.PROTECTED_FLAG
, B.DEFAULT_CONTEXT_FIELD_NAME
, B.CONTEXT_DEFAULT_TYPE
, B.CONTEXT_DEFAULT_VALUE
, TL.DESCRIPTION
FROM FND_DESCRIPTIVE_FLEXS B
, FND_DESCRIPTIVE_FLEXS_TL TL
, JTM_FND_DESCR_FLEXS_ACC SEED
, CSM_DESCRIPTIVE_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