[Home] [Help] [Dependency Information]
Object Name: | WIP_EAM_DIRECT_ITEMS_INTERFAC# |
---|---|
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DESCRIPTION | VARCHAR2 | (240) | ||
PURCHASING_CATEGORY_ID | NUMBER | |||
OPERATION_SEQ_NUM | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
WIP_ENTITY_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
UNIT_PRICE | NUMBER | |||
AUTO_REQUEST_MATERIAL | VARCHAR2 | (10) | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | ||
REQUIRED_QUANTITY | NUMBER | |||
UOM | VARCHAR2 | (10) | ||
NEED_BY_DATE | DATE | |||
CREATION_DATE | DATE | |||
REFERENCE | NUMBER | |||
HEADER_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
ROW_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DESCRIPTION
, PURCHASING_CATEGORY_ID
, OPERATION_SEQ_NUM
, DEPARTMENT_ID
, WIP_ENTITY_ID
, ORGANIZATION_ID
, UNIT_PRICE
, AUTO_REQUEST_MATERIAL
, SUGGESTED_VENDOR_NAME
, REQUIRED_QUANTITY
, UOM
, NEED_BY_DATE
, CREATION_DATE
, REFERENCE
, HEADER_ID
, BATCH_ID
, ROW_ID
FROM WIP.WIP_EAM_DIRECT_ITEMS_INTERFAC#;
|
|
|