[Home] [Help] [Dependency Information]
Object Name: | IC_WHSE_REL# |
---|---|
Object Type: | VIEW |
Owner: | GMI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WHSEREL_ID | NUMBER | (15) | Yes | |
SOURCE_WHSE | VARCHAR2 | (4) | ||
DEST_WHSE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | ||
FIXED_LEADTIME | NUMBER | Yes | ||
VARIABLE_LEADTIME | NUMBER | Yes | ||
INNER_TIMEFENCE | NUMBER | Yes | ||
OUTER_TIMEFENCE | NUMBER | Yes | ||
MIN_QTY | NUMBER | Yes | ||
MAX_QTY | NUMBER | Yes | ||
STD_QTY | NUMBER | Yes | ||
RULE_TYPE | NUMBER | (5) | Yes | |
PREFERENCE | NUMBER | (5) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
DELETE_MARK | NUMBER | (5) | Yes | |
TRANS_CNT | NUMBER | (10) | ||
TEXT_CODE | NUMBER | (10) | ||
TRANSFER_TYPE | NUMBER | (5) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT WHSEREL_ID
, SOURCE_WHSE
, DEST_WHSE
, ITEM_ID
, FIXED_LEADTIME
, VARIABLE_LEADTIME
, INNER_TIMEFENCE
, OUTER_TIMEFENCE
, MIN_QTY
, MAX_QTY
, STD_QTY
, RULE_TYPE
, PREFERENCE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DELETE_MARK
, TRANS_CNT
, TEXT_CODE
, TRANSFER_TYPE
, LAST_UPDATE_LOGIN
FROM GMI.IC_WHSE_REL#;
|
|
|