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

TABLE: MRP.MRP_ITEM_WIP_ENTITIES

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


MRP_ITEM_WIP_ENTITIES stores a copy of all active discrete jobs.
.
SCHEDULED_COMPLETION_DATE must contain a valid workdate. If the
completion date of the job is not defined as a valid workdate in
Oracle Work in Process, the Snapshot will shift this date to the next
valid workdate.
.
This table is populated by the Snapshot, and is used by the Planner.
This table is derived mainly from WIP_DISCRETE_JOBS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_ITEM_WIP_ENTITIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnINVENTORY_ITEM_ID
ColumnWIP_ENTITY_ID
MRP_ITEM_WIP_ENTITIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
WIP_ENTITY_ID NUMBER
Yes WIP job or repetitive assembly 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
WIP_ENTITY_NAME VARCHAR2 (240) Yes WIP entity name
JOB_QUANTITY NUMBER
Yes Outstanding job quantity
QUANTITY_COMPLETED NUMBER
Yes Quantity completed
QUANTITY_SCRAPPED NUMBER
Yes Quantity scrapped
EXPECTED_SCRAP_QUANTITY NUMBER
Yes Expected scrap quantity
SCHEDULE_COMPLETION_DATE DATE
Yes Order schedule completion date
FIRM_PLANNED_STATUS_TYPE NUMBER
Yes Order firm status code
START_DATE DATE
Yes Work order start date
STATUS_CODE NUMBER
Yes Job status code
REVISION VARCHAR2 (3)
Inventory item revision code
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
WIP_JOB_TYPE NUMBER

Job type
DEMAND_CLASS VARCHAR2 (30)
Not currently used
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
PLANNING_GROUP VARCHAR2 (30)
Planning group
SCHEDULE_GROUP_ID NUMBER

Schedule Group Identifier
BUILD_SEQUENCE NUMBER

Build Sequence
LINE_ID NUMBER

Line identifier
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate Bom Designator
ENTITY_TYPE NUMBER

WIP entity type
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Unit number
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      WIP_ENTITY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WIP_ENTITY_NAME
,      JOB_QUANTITY
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      EXPECTED_SCRAP_QUANTITY
,      SCHEDULE_COMPLETION_DATE
,      FIRM_PLANNED_STATUS_TYPE
,      START_DATE
,      STATUS_CODE
,      REVISION
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_JOB_TYPE
,      DEMAND_CLASS
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      LINE_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      ENTITY_TYPE
,      END_ITEM_UNIT_NUMBER
FROM MRP.MRP_ITEM_WIP_ENTITIES;

Dependencies

[top of page]

MRP.MRP_ITEM_WIP_ENTITIES does not reference any database object

MRP.MRP_ITEM_WIP_ENTITIES is referenced by following:

SchemaAPPS
SynonymMRP_ITEM_WIP_ENTITIES