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

TABLE: MSC.MSC_PLAN_ORGANIZATIONS

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


This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). This table also contains the different companies which are collaborating in a supply or demand plan in Oracle Supply Chain Hub.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_PLAN_ORGANIZATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source instance identifier for the org
ORGANIZATION_CODE VARCHAR2 (7) Yes Organization code
NET_WIP NUMBER
Yes Flag to indicate whether to allow netting from WIP
NET_RESERVATIONS NUMBER
Yes Flag to indicate whether to allow netting from reservations
NET_PURCHASING NUMBER
Yes Flag to indicate whether to allow netting from purchase orders
PLAN_SAFETY_STOCK NUMBER
Yes Flag to indicate whether to allow netting from safety stock
SIMULATION_SET VARCHAR2 (10)
Simulation set identifier
BILL_OF_RESOURCES VARCHAR2 (10)
Bill of resource name
PLAN_LEVEL NUMBER
Yes Plan level
ORGANIZATION_DESCRIPTION VARCHAR2 (250)
Description of the organization
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

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
COLLAB_ROLE NUMBER

Collaboration Role
CONTACT VARCHAR2 (240)
Collaboration contact
CALENDAR_CODE NUMBER

Calendar code used by exchange
INCLUDE_SALESORDER NUMBER

Include sales order
PLAN_COMPLETION_DATE DATE

Plan completion date for exchange plans
NET_ON_HAND NUMBER

Net On Hand
SO_LRN NUMBER

Last refresh number for entity sales order
DS_ENABLED_FLAG NUMBER

1 yes, 2 No
CURR_DS_ENABLED_FLAG NUMBER

Current value of DS_ENABLED_FLAG
FROZEN_HORIZON_DAYS NUMBER

Number of days from plan start days which are frozen for ds
CURR_FROZEN_HORIZON_DAYS NUMBER

Current value of Frozen_Horizon_Days
RESPECT_MAX_ACCEPTABLE_DAYS NUMBER

1 yes, 2 No
CURR_RESPECT_MAX_ACCEPT_DAYS NUMBER

Current value of Respect_Max_Acceptable_days
MINIMIZE_SUPPLY_LEAD_TIME NUMBER

1 yes, 2 No
CURR_MIN_SUPPLY_LEAD_TIME NUMBER

Current value Minimize_Supply_Lead_time
INCLUDE_PRODUCTION_SCHEDULE NUMBER

Flag to indicate that Production Schedule is Included
PRODUCTION_SCHEDULE_ID NUMBER

Production Schedule Identifier
FIRM_HORIZON_DAYS NUMBER

Firm Horizon Days
Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      NET_WIP
,      NET_RESERVATIONS
,      NET_PURCHASING
,      PLAN_SAFETY_STOCK
,      SIMULATION_SET
,      BILL_OF_RESOURCES
,      PLAN_LEVEL
,      ORGANIZATION_DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      COLLAB_ROLE
,      CONTACT
,      CALENDAR_CODE
,      INCLUDE_SALESORDER
,      PLAN_COMPLETION_DATE
,      NET_ON_HAND
,      SO_LRN
,      DS_ENABLED_FLAG
,      CURR_DS_ENABLED_FLAG
,      FROZEN_HORIZON_DAYS
,      CURR_FROZEN_HORIZON_DAYS
,      RESPECT_MAX_ACCEPTABLE_DAYS
,      CURR_RESPECT_MAX_ACCEPT_DAYS
,      MINIMIZE_SUPPLY_LEAD_TIME
,      CURR_MIN_SUPPLY_LEAD_TIME
,      INCLUDE_PRODUCTION_SCHEDULE
,      PRODUCTION_SCHEDULE_ID
,      FIRM_HORIZON_DAYS
FROM MSC.MSC_PLAN_ORGANIZATIONS;

Dependencies

[top of page]

MSC.MSC_PLAN_ORGANIZATIONS does not reference any database object

MSC.MSC_PLAN_ORGANIZATIONS is referenced by following:

SchemaAPPS
SynonymMSC_PLAN_ORGANIZATIONS