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

TABLE: MRP.MRP_KANBAN_PLANS

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


MRP_KANBAN_PLANS stores simulation kanban plan identifiers and names.
A kanban plan identifier uniquely identifies a simulation kanban plan.
INPUT_DESIGNATOR stores the forecast or schedule name that is used as
input for kanban demand.
This table is populated by the Define Kanban Names form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_KANBAN_PLANS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnKANBAN_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
KANBAN_PLAN_ID NUMBER
Yes Kanban plan identifier
KANBAN_DESIGNATOR VARCHAR2 (10) Yes Kanban designator
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DESCRIPTION VARCHAR2 (50)
Kanban designator code description
INPUT_TYPE NUMBER
Yes Type of input to the plan: Forecast, MDS or MPS
INPUT_DESIGNATOR VARCHAR2 (10)
Designator for a forecast, MDS or MPS used as input to the plan
PLAN_START_DATE DATE

Demand start date used in the Kanban planning process
PLAN_COMPLETION_DATE DATE

Plan completion date and time
DISABLE_DATE DATE

Plan disable date
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
BOM_EFFECTIVITY_DATE DATE

BOM Effectivity Date used in the Kanban Planning process
PLAN_CUTOFF_DATE DATE

Demand Cutoff Date used in the Kanban planning process
Query Text

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


SELECT ORGANIZATION_ID
,      KANBAN_PLAN_ID
,      KANBAN_DESIGNATOR
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      INPUT_TYPE
,      INPUT_DESIGNATOR
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      DISABLE_DATE
,      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
,      BOM_EFFECTIVITY_DATE
,      PLAN_CUTOFF_DATE
FROM MRP.MRP_KANBAN_PLANS;

Dependencies

[top of page]

MRP.MRP_KANBAN_PLANS does not reference any database object

MRP.MRP_KANBAN_PLANS is referenced by following:

SchemaMRP
ViewMRP_KANBAN_PLANS#