Skip to content

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

TABLE: WIP.WIP_MAT_REQMENTS_INTERFACE

Object Details
Object Name: WIP_MAT_REQMENTS_INTERFACE
Object Type: TABLE
Owner: WIP
Subobject Name:
Status: VALID


stores info about material requirements defined for a job


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item Identifier for assembly that the job or schedule creates
ORGANIZATION_ID NUMBER

Organization identifier
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
QUANTITY_PER_ASSEMBLY NUMBER

Part usage quantity
DEPARTMENT_ID NUMBER

Department of this resource, if different from that of parent operation
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER

Part quantity required
RELEASED_QUANTITY NUMBER

This column stores material requirement at released time
QUANTITY_ISSUED NUMBER

Part quantity issued
MRP_NET_FLAG NUMBER

Determines whether or not MRP should consider the component requirement in its netting process
MPS_REQUIRED_QUANTITY NUMBER

Quantity used by MPS relief process
MPS_DATE_REQUIRED DATE

Date used by MPS relief process
COMPONENT_SEQUENCE_ID NUMBER

BOM component sequence number for the material
COMMENTS VARCHAR2 (240)
comments
AUTO_REQUEST_MATERIAL VARCHAR2 (10)
Auto request material flag for the material
UNIT_PRICE NUMBER

Unit price of the material
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
HEADER_ID NUMBER

Header identifier
BATCH_ID NUMBER

Batch Id used in grouping operation resources across jobs
ROW_ID NUMBER

Row identifier
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      QUANTITY_PER_ASSEMBLY
,      DEPARTMENT_ID
,      WIP_SUPPLY_TYPE
,      DATE_REQUIRED
,      REQUIRED_QUANTITY
,      RELEASED_QUANTITY
,      QUANTITY_ISSUED
,      MRP_NET_FLAG
,      MPS_REQUIRED_QUANTITY
,      MPS_DATE_REQUIRED
,      COMPONENT_SEQUENCE_ID
,      COMMENTS
,      AUTO_REQUEST_MATERIAL
,      UNIT_PRICE
,      CREATED_BY
,      CREATION_DATE
,      HEADER_ID
,      BATCH_ID
,      ROW_ID
FROM WIP.WIP_MAT_REQMENTS_INTERFACE;

Dependencies

[top of page]

WIP.WIP_MAT_REQMENTS_INTERFACE does not reference any database object

WIP.WIP_MAT_REQMENTS_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_MAT_REQMENTS_INTERFACE#