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

VIEW: APPS.MSD_CS_DEFN_COLUMN_DTLS_V

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

View Type

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


This view provides Data Stream's Column Details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CS_COLUMN_DTLS_ID NUMBER (15) Yes Primary Key.
CS_DEFINITION_ID NUMBER (15) Yes Data Definition ID.
DEFINITION_NAME VARCHAR2 (30) Yes Unique Short Name of the Custom Stream Definition.
SOURCE_VIEW_COLUMN_NAME VARCHAR2 (30)
Source View Column Name.
PLANNING_VIEW_COLUMN_NAME VARCHAR2 (30)
Planning View Column Name.
COLUMN_IDENTIFIER VARCHAR2 (30) Yes Column Identifier.
TABLE_COLUMN VARCHAR2 (30) Yes Table Column.
COLUMN_IDENTIFIER_DESC VARCHAR2 (100) Yes Column Identifier Description.
IDENTIFIER_TYPE VARCHAR2 (30) Yes Identifier Type.
AGGREGATION_TYPE VARCHAR2 (30)
Aggregation Type.
ALLOCATION_TYPE VARCHAR2 (30)
Allocation Type.
AGGREGATION_TYPE_DESC VARCHAR2 (80)
Aggregation Type Description.
ALLOCATION_TYPE_DESC VARCHAR2 (80)
Allocation Type Description.
USER_PROMPT VARCHAR2 (80)
User Prompt.
UOM_CONVERSION_FLAG VARCHAR2 (30)
UOM Conversion Flag.
CREATION_DATE DATE
Yes Standard Who Column.
CREATED_BY NUMBER
Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER

Standard Who Column.
REQUEST_ID NUMBER

Extended Who Column.
PROGRAM_APPLICATION_ID NUMBER

Extended Who Column.
PROGRAM_ID NUMBER

Extended Who Column.
PROGRAM_UPDATE_DATE DATE

Extended Who Column.
Query Text

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


SELECT CS_COLUMN_DTLS_ID
,      CS_DEFINITION_ID
,      DEFINITION_NAME
,      SOURCE_VIEW_COLUMN_NAME
,      PLANNING_VIEW_COLUMN_NAME
,      COLUMN_IDENTIFIER
,      TABLE_COLUMN
,      COLUMN_IDENTIFIER_DESC
,      IDENTIFIER_TYPE
,      AGGREGATION_TYPE
,      ALLOCATION_TYPE
,      AGGREGATION_TYPE_DESC
,      ALLOCATION_TYPE_DESC
,      USER_PROMPT
,      UOM_CONVERSION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.MSD_CS_DEFN_COLUMN_DTLS_V;

Dependencies

[top of page]

APPS.MSD_CS_DEFN_COLUMN_DTLS_V references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL
ViewMSD_CS_CLMN_IDENTIFIERS_VL
SynonymMSD_CS_DEFINITIONS
SynonymMSD_CS_DEFN_COLUMN_DTLS
APPS.MSD_CS_DEFN_COLUMN_DTLS_V is referenced by following:

SchemaAPPS
ViewMSD_CS_CLMN_DIM_DTLS_V
Package BodyMSD_CS_COLLECTION - show dependent code
Package BodyMSD_CS_DFN_UTL - show dependent code
PL/SQL PackageMSD_CS_DFN_UTL - show dependent code
Package BodyMSD_STRIPE_DEMAND_PLAN - show dependent code
Package BodyMSD_VALIDATE_DEMAND_PLAN - show dependent code