[Home] [Help]
[Dependency Information]
Object Name: | WIP_MAT_REQMENTS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
stores info about material requirements defined for a job
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
WIP.WIP_MAT_REQMENTS_INTERFACE does not reference any database object
WIP.WIP_MAT_REQMENTS_INTERFACE is referenced by following:
|
|
|