[Home] [Help] [Dependency Information]
Object Name: | MRP_PLAN_ORGANIZATIONS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_PLAN_ORGANIZATIONS |
Subobject Name: | |
Status: | VALID |
MRP_PLAN_ORGANIZATIONS stores the organizations that are planned by a
MPS, MRP, or DRP plan. This table is a child of MRP_PLANS and is used
by the Oracle Supply Chain Planning module
.
Oracle Supply Chain Planning maintains 2 versions of the planned
organizations. Current, which reflects the current list of
organizations, and Last which reflects the organizations planned in
the last run of the MPS, MRP, or DRP plan.
.
This table is populated by the Define Plan Options form.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_PLAN_ORGANIZATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
COMPILE_DESIGNATOR PLANNED_ORGANIZATION PLAN_LEVEL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
PLANNED_ORGANIZATION | NUMBER | Yes | Planned organization identifier | |
PLAN_LEVEL | NUMBER | Yes | Plan level | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
NET_WIP | NUMBER | Yes | Net work in process | |
NET_RESERVATIONS | NUMBER | Yes | Net material reservations | |
NET_PURCHASING | NUMBER | Yes | Net purchasing supply | |
PLAN_SAFETY_STOCK | NUMBER | Yes | Plan safety stock | |
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 | |
BILLS_OF_RESOURCES | VARCHAR2 | (10) | Bill of Resources | |
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 | |
SIMULATION_SET | VARCHAR2 | (10) | Simulation set name | |
BILL_OF_RESOURCES | VARCHAR2 | (10) | Bill of resources name |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, PLANNED_ORGANIZATION
, PLAN_LEVEL
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, NET_WIP
, NET_RESERVATIONS
, NET_PURCHASING
, PLAN_SAFETY_STOCK
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, BILLS_OF_RESOURCES
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SIMULATION_SET
, BILL_OF_RESOURCES
FROM MRP.MRP_PLAN_ORGANIZATIONS;
MRP.MRP_PLAN_ORGANIZATIONS does not reference any database object
MRP.MRP_PLAN_ORGANIZATIONS is referenced by following:
|
|
|