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

TABLE: MRP.MRP_MATERIAL_PLANS

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


MRP_MATERIAL_PLANS stores the horizontal material plan for a MRP, DRP
or MPS plan.The horizontal plan data is generated and stored in this
table whenever the user navigates to the horizontal plan window of the
Planner Workbench.
.
BUCKET_TYPE contains the units for storing horizontal plan data, for
example, days, weeks or periods.
HORIZONTAL_PLAN_TYPE_TEXT refers to the type of supply or demand for
which the horizontal plan is stored such as Planned orders, Discrete
jobs etc.
The actual values of the horizontal plan data for each bucket type are
stored in the QUANTITY1 to QUANTITY36 columns.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_MATERIAL_PLANS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnINVENTORY_ITEM_ID
ColumnBUCKET_TYPE
ColumnHORIZONTAL_PLAN_TYPE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Query identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
PLAN_ORGANIZATION_ID NUMBER

Organization of the plan
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ITEM_SEGMENTS VARCHAR2 (255)
Item segments
HORIZONTAL_PLAN_TYPE NUMBER
Yes Horizontal plan type
BUCKET_TYPE NUMBER
Yes Bucket type
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
HORIZONTAL_PLAN_TYPE_TEXT VARCHAR2 (80)
Horizontal plan type text
QUANTITY1 NUMBER

Generic quantity column
QUANTITY2 NUMBER

Generic quantity column
QUANTITY3 NUMBER

Generic quantity column
QUANTITY4 NUMBER

Generic quantity column
QUANTITY5 NUMBER

Generic quantity column
QUANTITY6 NUMBER

Generic quantity column
QUANTITY7 NUMBER

Generic quantity column
QUANTITY8 NUMBER

Generic quantity column
QUANTITY9 NUMBER

Generic quantity column
QUANTITY10 NUMBER

Generic quantity column
QUANTITY11 NUMBER

Generic quantity column
QUANTITY12 NUMBER

Generic quantity column
QUANTITY13 NUMBER

Generic quantity column
QUANTITY14 NUMBER

Generic quantity column
QUANTITY15 NUMBER

Generic quantity column
QUANTITY16 NUMBER

Generic quantity column
QUANTITY17 NUMBER

Generic quantity column
QUANTITY18 NUMBER

Generic quantity column
QUANTITY19 NUMBER

Generic quantity column
QUANTITY20 NUMBER

Generic quantity column
QUANTITY21 NUMBER

Generic quantity column
QUANTITY22 NUMBER

Generic quantity column
QUANTITY23 NUMBER

Generic quantity column
QUANTITY24 NUMBER

Generic quantity column
QUANTITY25 NUMBER

Generic quantity column
QUANTITY26 NUMBER

Generic quantity column
QUANTITY27 NUMBER

Generic quantity column
QUANTITY28 NUMBER

Generic quantity column
QUANTITY29 NUMBER

Generic quantity column
QUANTITY30 NUMBER

Generic quantity column
QUANTITY31 NUMBER

Generic quantity column
QUANTITY32 NUMBER

Generic quantity column
QUANTITY33 NUMBER

Generic quantity column
QUANTITY34 NUMBER

Generic quantity column
QUANTITY35 NUMBER

Generic quantity column
QUANTITY36 NUMBER

Generic quantity column
Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      PLAN_ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      HORIZONTAL_PLAN_TYPE
,      BUCKET_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      HORIZONTAL_PLAN_TYPE_TEXT
,      QUANTITY1
,      QUANTITY2
,      QUANTITY3
,      QUANTITY4
,      QUANTITY5
,      QUANTITY6
,      QUANTITY7
,      QUANTITY8
,      QUANTITY9
,      QUANTITY10
,      QUANTITY11
,      QUANTITY12
,      QUANTITY13
,      QUANTITY14
,      QUANTITY15
,      QUANTITY16
,      QUANTITY17
,      QUANTITY18
,      QUANTITY19
,      QUANTITY20
,      QUANTITY21
,      QUANTITY22
,      QUANTITY23
,      QUANTITY24
,      QUANTITY25
,      QUANTITY26
,      QUANTITY27
,      QUANTITY28
,      QUANTITY29
,      QUANTITY30
,      QUANTITY31
,      QUANTITY32
,      QUANTITY33
,      QUANTITY34
,      QUANTITY35
,      QUANTITY36
FROM MRP.MRP_MATERIAL_PLANS;

Dependencies

[top of page]

MRP.MRP_MATERIAL_PLANS does not reference any database object

MRP.MRP_MATERIAL_PLANS is referenced by following:

SchemaAPPS
SynonymMRP_MATERIAL_PLANS