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

TABLE: MSC.MSC_PLAN_ORG_STATUS

Object Details
Object Name: MSC_PLAN_ORG_STATUS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_PLAN_ORG_STATUS
Subobject Name:
Status: VALID


This table contains the history of the statuses for each organization in the plan. The statuses are maintained to let the collaborating organization know how to respond depending on their current status. The plan status history is also maintained under the dummy organization id of -1. Records are inserted into this table during the plan invitation process, loads, netting runs and plan closure. The parties in the plan receive notifications each time their status gets updated explaining what event caused the status to change and how they must respond to it. The statuses of the collaborating plans and the plan can be viewed in the 'View Plans' user interface of supply chain hub.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_PLAN_ORG_STATUS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnSTATUS_DATE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Contains the plan identifier
ORGANIZATION_ID NUMBER
Yes Contains the party identifier
SR_INSTANCE_ID NUMBER
Yes Contains the source instance identifier, currently defaulted to -1
STATUS NUMBER
Yes Contains the status code of the organization in the plan
STATUS_DATE DATE
Yes Contains the date the record was inserted.
NUMBER1 NUMBER

Internal column for VMI planning
Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      STATUS
,      STATUS_DATE
,      NUMBER1
FROM MSC.MSC_PLAN_ORG_STATUS;

Dependencies

[top of page]

MSC.MSC_PLAN_ORG_STATUS does not reference any database object

MSC.MSC_PLAN_ORG_STATUS is referenced by following:

SchemaAPPS
SynonymMSC_PLAN_ORG_STATUS