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

VIEW: APPS.MSD_CS_CLMN_IDENTIFIERS_VL

Object Details
Object Name: MSD_CS_CLMN_IDENTIFIERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_CS_CLMN_IDENTIFIERS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view for Custom Stream Column identifiers


[View Source]

Columns
Name Datatype Length Mandatory Comments
COLUMN_IDENTIFIER VARCHAR2 (30) Yes Column Identifier. Unique Key
DESCRIPTION VARCHAR2 (100) Yes Column Name
IDENTIFIER_TYPE VARCHAR2 (30) Yes Identifier Type. Based on FND_LOOKUP - MSD_CS_IDENTIFIERS
IDENTIFIER_TYPE_DESC VARCHAR2 (80) Yes Identifier Type Description.
USER_PROMPT VARCHAR2 (80)
User Prompt
SYSTEM_FLAG VARCHAR2 (240)
System Flag. 'Y' for Oracle Defined Column Identifiers.
CREATION_DATE DATE

Standard Who Column.
CREATED_BY NUMBER

Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATED_BY NUMBER

Standard Who Column.
LAST_UPDATE_LOGIN NUMBER

Standard Who Column.
Query Text

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


SELECT COLUMN_IDENTIFIER
,      DESCRIPTION
,      IDENTIFIER_TYPE
,      IDENTIFIER_TYPE_DESC
,      USER_PROMPT
,      SYSTEM_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.MSD_CS_CLMN_IDENTIFIERS_VL;

Dependencies

[top of page]

APPS.MSD_CS_CLMN_IDENTIFIERS_VL references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL
SynonymMSD_CS_CLMN_IDENTIFIERS
SynonymMSD_CS_CLMN_IDENTIFIERS_TL
APPS.MSD_CS_CLMN_IDENTIFIERS_VL is referenced by following:

SchemaAPPS
ViewMSD_CS_DEFN_COLUMN_DTLS_V
ViewMSD_DP_PARAMETERS_CS_V
ViewMSD_DP_SCENARIOS_VL