[Home] [Help] [Dependency Information]
Object Name: | OE_UPGRADE_LOG# |
---|---|
Object Type: | VIEW |
Owner: | ONT |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | |||
OLD_LINE_ID | NUMBER | |||
OLD_LINE_DETAIL_ID | NUMBER | |||
PICKING_LINE_ID | NUMBER | |||
NEW_LINE_ID | NUMBER | |||
RETURN_QTY_AVAILABLE | NUMBER | |||
NEW_LINE_NUMBER | NUMBER | |||
MTL_SALES_ORDER_ID | NUMBER | |||
COMMENTS | VARCHAR2 | (240) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
DELIVERY | NUMBER | |||
MODULE | VARCHAR2 | (2) | ||
CYCLE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, OLD_LINE_ID
, OLD_LINE_DETAIL_ID
, PICKING_LINE_ID
, NEW_LINE_ID
, RETURN_QTY_AVAILABLE
, NEW_LINE_NUMBER
, MTL_SALES_ORDER_ID
, COMMENTS
, CREATION_DATE
, LAST_UPDATE_DATE
, DELIVERY
, MODULE
, CYCLE_ID
FROM ONT.OE_UPGRADE_LOG#;
|
|
|