VIEW: APPS.GLFV_CHARTS_OF_ACCOUNTS

Source

View Text - Preformatted

SELECT COA.ID_FLEX_NUM, COA_TL.ID_FLEX_STRUCTURE_NAME, COA.CONCATENATED_SEGMENT_DELIMITER, COA_TL.DESCRIPTION, '_LA:COA.CROSS_SEGMENT_VALIDATION_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:COA.DYNAMIC_INSERTS_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:COA.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:COA.FREEZE_FLEX_DEFINITION_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:COA.FREEZE_STRUCTURED_HIER_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_LA:COA.SHORTHAND_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING', COA.SHORTHAND_LENGTH, COA_TL.SHORTHAND_PROMPT FROM FND_ID_FLEX_STRUCTURES COA, FND_ID_FLEX_STRUCTURES_TL COA_TL WHERE (COA.APPLICATION_ID = COA_TL.APPLICATION_ID) AND (COA.ID_FLEX_CODE = COA_TL.ID_FLEX_CODE) AND (COA.ID_FLEX_NUM = COA_TL.ID_FLEX_NUM) AND (COA_TL.LANGUAGE = USERENV('LANG') AND COA_TL.APPLICATION_ID = 101 AND COA_TL.ID_FLEX_CODE = 'GL#') WITH READ ONLY

View Text - HTML Formatted

SELECT COA.ID_FLEX_NUM
, COA_TL.ID_FLEX_STRUCTURE_NAME
, COA.CONCATENATED_SEGMENT_DELIMITER
, COA_TL.DESCRIPTION
, '_LA:COA.CROSS_SEGMENT_VALIDATION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COA.DYNAMIC_INSERTS_ALLOWED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COA.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COA.FREEZE_FLEX_DEFINITION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COA.FREEZE_STRUCTURED_HIER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:COA.SHORTHAND_ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, COA.SHORTHAND_LENGTH
, COA_TL.SHORTHAND_PROMPT
FROM FND_ID_FLEX_STRUCTURES COA
, FND_ID_FLEX_STRUCTURES_TL COA_TL
WHERE (COA.APPLICATION_ID = COA_TL.APPLICATION_ID)
AND (COA.ID_FLEX_CODE = COA_TL.ID_FLEX_CODE)
AND (COA.ID_FLEX_NUM = COA_TL.ID_FLEX_NUM)
AND (COA_TL.LANGUAGE = USERENV('LANG')
AND COA_TL.APPLICATION_ID = 101
AND COA_TL.ID_FLEX_CODE = 'GL#') WITH READ ONLY