[Home] [Help] [Dependency Information]
Object Name: | WIP_MAT_REQMENTS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
WIP_ENTITY_ID | NUMBER | |||
OPERATION_SEQ_NUM | NUMBER | |||
QUANTITY_PER_ASSEMBLY | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
WIP_SUPPLY_TYPE | NUMBER | |||
DATE_REQUIRED | DATE | |||
REQUIRED_QUANTITY | NUMBER | |||
RELEASED_QUANTITY | NUMBER | |||
QUANTITY_ISSUED | NUMBER | |||
MRP_NET_FLAG | NUMBER | |||
MPS_REQUIRED_QUANTITY | NUMBER | |||
MPS_DATE_REQUIRED | DATE | |||
COMPONENT_SEQUENCE_ID | NUMBER | |||
COMMENTS | VARCHAR2 | (240) | ||
AUTO_REQUEST_MATERIAL | VARCHAR2 | (10) | ||
UNIT_PRICE | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
HEADER_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
ROW_ID | NUMBER |
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#;
|
|
|