View: FND_FLEX_SHORTHAND_ALIAS_V

Product:	FND - Application Object Library
Description:	View of FND_APPLICATION_UNKNOWN_VIEW, FND_ID_FLEXS, and FND_ID_FLEX_STRUCTURES_VL
Implementation/DBA Data:	APPS.FND_FLEX_SHORTHAND_ALIAS_V

View Text

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'

Columns