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

TABLE: MRP.MRP_SCHEDULE_DESIGNATORS

Object Details
Object Name: MRP_SCHEDULE_DESIGNATORS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_SCHEDULE_DESIGNATORS
Subobject Name:
Status: VALID


MRP_SCHEDULE_DESIGNATORS stores MPS and MDS schedule names. A
schedule name uniquely identifies a master schedule.
.
MPS_RELIEF indicates whether or not the Planning Manager should
consume this master demand or master production schedule.
.
INVENTORY_ATP_FLAG indicates whether or not inventory can consider
this master production schedule as a source of supply as defined by
ATP rules. It will always be No for master demand schedules.
.
This table is populated by the Define Master Schedule Names form.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_SCHEDULE_DESIGNATORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULE_DESIGNATOR
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_DESIGNATOR VARCHAR2 (10) Yes Master schedule identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
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
SCHEDULE_TYPE NUMBER
Yes Schedule type code
MPS_RELIEF NUMBER
Yes Perform MPS relief against this designator
INVENTORY_ATP_FLAG NUMBER
Yes ATP supply flag
DESCRIPTION VARCHAR2 (50)
Designator description
DISABLE_DATE DATE

Designator disable date
DEMAND_CLASS VARCHAR2 (30)
Demand class identifier
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
USE_NEW_PLANNER NUMBER

Use new planner code
ORGANIZATION_SELECTION NUMBER

Organization selection to specify if schedule is for single, all, or multiple organizations
PRODUCTION NUMBER

flag for auto release
Query Text

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


SELECT SCHEDULE_DESIGNATOR
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SCHEDULE_TYPE
,      MPS_RELIEF
,      INVENTORY_ATP_FLAG
,      DESCRIPTION
,      DISABLE_DATE
,      DEMAND_CLASS
,      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
,      USE_NEW_PLANNER
,      ORGANIZATION_SELECTION
,      PRODUCTION
FROM MRP.MRP_SCHEDULE_DESIGNATORS;

Dependencies

[top of page]

MRP.MRP_SCHEDULE_DESIGNATORS does not reference any database object

MRP.MRP_SCHEDULE_DESIGNATORS is referenced by following:

SchemaMRP
ViewMRP_SCHEDULE_DESIGNATORS#