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

VIEW: MSD.MSD_DP_PLANNING_PERCENTAGES#

Object Details
Object Name: MSD_DP_PLANNING_PERCENTAGES#
Object Type: VIEW
Owner: MSD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes
DP_SCENARIO_ID NUMBER
Yes
REVISION NUMBER
Yes
INSTANCE VARCHAR2 (40) Yes
SR_ORGANIZATION_PK VARCHAR2 (240)
ORGANIZATION_LEVEL_PK NUMBER

COMPONENT_SEQUENCE_ID NUMBER
Yes
SR_ASSEMBLY_ITEM_PK VARCHAR2 (240)
ASSEMBLY_ITEM_LEVEL_PK NUMBER

SR_COMPONENT_ITEM_PK VARCHAR2 (240)
COMPONENT_ITEM_LEVEL_PK NUMBER

PLANNING_FACTOR NUMBER

DATE_FROM DATE

DATE_TO DATE

PLAN_PERCENT_TYPE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT DEMAND_PLAN_ID
,      DP_SCENARIO_ID
,      REVISION
,      INSTANCE
,      SR_ORGANIZATION_PK
,      ORGANIZATION_LEVEL_PK
,      COMPONENT_SEQUENCE_ID
,      SR_ASSEMBLY_ITEM_PK
,      ASSEMBLY_ITEM_LEVEL_PK
,      SR_COMPONENT_ITEM_PK
,      COMPONENT_ITEM_LEVEL_PK
,      PLANNING_FACTOR
,      DATE_FROM
,      DATE_TO
,      PLAN_PERCENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSD.MSD_DP_PLANNING_PERCENTAGES#;

Dependencies

[top of page]

MSD.MSD_DP_PLANNING_PERCENTAGES# references the following:

SchemaMSD
TableMSD_DP_PLANNING_PERCENTAGES
MSD.MSD_DP_PLANNING_PERCENTAGES# is referenced by following:

SchemaAPPS
SynonymMSD_DP_PLANNING_PERCENTAGES