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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FND_FLEX_SHORTHAND_ALIAS_V

Object Details

Object Name:	FND_FLEX_SHORTHAND_ALIAS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_FLEX_SHORTHAND_ALIAS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Application identifier
APPLICATION_NAME	VARCHAR2	(240)	Yes	Name of the application owning the key flexfield
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Short name of the application owning the key flexfield
ID_FLEX_CODE	VARCHAR2	(4)	Yes	Code of the key flexfield
ID_FLEX_NAME	VARCHAR2	(30)	Yes	Name of the key flexfield
FLEX_DESCRIPTION	VARCHAR2	(240)		Description of the key flexfield
ID_FLEX_NUM	NUMBER	(15)	Yes	Structure number of the key flexfield structure
ID_FLEX_STRUCTURE_NAME	VARCHAR2	(30)	Yes	Name of the key flexfield structure
STRUCT_DESCRIPTION	VARCHAR2	(240)		Description of the key flexfield structure
SHORTHAND_PROMPT	VARCHAR2	(80)		Prompt for the shorthand alias
SHORTHAND_LENGTH	NUMBER	(3)		Maximum length of the shorthand alias name
ID_CODE_NUM	VARCHAR2	(86)		Concatenation of the application identifier, code, and structure number separated by '-' (used as the context value for "Key Flexfield Shorthand Aliases" descriptive flexfield in the Shorthand Aliases window

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      APPLICATION_NAME
,      APPLICATION_SHORT_NAME
,      ID_FLEX_CODE
,      ID_FLEX_NAME
,      FLEX_DESCRIPTION
,      ID_FLEX_NUM
,      ID_FLEX_STRUCTURE_NAME
,      STRUCT_DESCRIPTION
,      SHORTHAND_PROMPT
,      SHORTHAND_LENGTH
,      ID_CODE_NUM
FROM APPS.FND_FLEX_SHORTHAND_ALIAS_V;

Dependencies

[top of page]

APPS.FND_FLEX_SHORTHAND_ALIAS_V references the following:

APPS: FND_APPLICATION_VL; FND_ID_FLEXS; FND_ID_FLEX_STRUCTURES_VL

APPS.FND_FLEX_SHORTHAND_ALIAS_V is not referenced by any database object