VIEW: APPS.FND_FLEX_SHORTHAND_ALIAS_V

Source

View Text - Preformatted

SELECT A.APPLICATION_ID , A.APPLICATION_NAME , A.APPLICATION_SHORT_NAME , I.ID_FLEX_CODE , I.ID_FLEX_NAME , I.DESCRIPTION , S.ID_FLEX_NUM , S.ID_FLEX_STRUCTURE_NAME , S.DESCRIPTION , S.SHORTHAND_PROMPT , S.SHORTHAND_LENGTH , A.APPLICATION_ID || '-' || I.ID_FLEX_CODE || '-' || S.ID_FLEX_NUM FROM FND_APPLICATION_VL A, FND_ID_FLEXS I, FND_ID_FLEX_STRUCTURES_VL S WHERE I.APPLICATION_ID = A.APPLICATION_ID AND S.APPLICATION_ID = I.APPLICATION_ID AND S.ID_FLEX_CODE = I.ID_FLEX_CODE AND S.SHORTHAND_ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT A.APPLICATION_ID
, A.APPLICATION_NAME
, A.APPLICATION_SHORT_NAME
, I.ID_FLEX_CODE
, I.ID_FLEX_NAME
, I.DESCRIPTION
, S.ID_FLEX_NUM
, S.ID_FLEX_STRUCTURE_NAME
, S.DESCRIPTION
, S.SHORTHAND_PROMPT
, S.SHORTHAND_LENGTH
, A.APPLICATION_ID || '-' || I.ID_FLEX_CODE || '-' || S.ID_FLEX_NUM
FROM FND_APPLICATION_VL A
, FND_ID_FLEXS I
, FND_ID_FLEX_STRUCTURES_VL S
WHERE I.APPLICATION_ID = A.APPLICATION_ID
AND S.APPLICATION_ID = I.APPLICATION_ID
AND S.ID_FLEX_CODE = I.ID_FLEX_CODE
AND S.SHORTHAND_ENABLED_FLAG = 'Y'