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

VIEW: APPS.MSD_DP_SEEDED_DOC_DIMENSIONS_V

Object Details
Object Name: MSD_DP_SEEDED_DOC_DIMENSIONS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view shows the dimensions data for seeded documents.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Identifier
DOCUMENT_ID NUMBER
Yes Document Identifier
DIMENSION_CODE VARCHAR2 (15) Yes Dimension Code
SEQUENCE_NUMBER NUMBER
Yes Order in which dimension appears in document
AXIS VARCHAR2 (15) Yes X/Y/Z
HIERARCHY_ID NUMBER

Hierarchy Identifier
SELECTION_TYPE VARCHAR2 (15)
Selection type. Possible values are List(L) and Script(S).
SELECTION_SCRIPT VARCHAR2 (4000)
Selection Script
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Enhanced Who Column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who Column
PROGRAM_ID NUMBER

Enhanced Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
Query Text

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


SELECT DEMAND_PLAN_ID
,      DOCUMENT_ID
,      DIMENSION_CODE
,      SEQUENCE_NUMBER
,      AXIS
,      HIERARCHY_ID
,      SELECTION_TYPE
,      SELECTION_SCRIPT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.MSD_DP_SEEDED_DOC_DIMENSIONS_V;

Dependencies

[top of page]

APPS.MSD_DP_SEEDED_DOC_DIMENSIONS_V references the following:

SchemaAPPS
SynonymMSD_DP_SEEDED_DOCUMENTS
SynonymMSD_DP_SEEDED_DOC_DIMENSIONS

APPS.MSD_DP_SEEDED_DOC_DIMENSIONS_V is not referenced by any database object