[Home] [Help] [Dependency Information]
Object Name: | OZF_ORDER_SALES_SUMRY_MV# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
SOLD_TO_CUST_ACCOUNT_ID | NUMBER | |||
SHIP_TO_SITE_USE_ID | NUMBER | |||
BILL_TO_SITE_USE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
SALES_QTY | NUMBER | |||
SALES_AMT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, SOLD_TO_CUST_ACCOUNT_ID
, SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, INVENTORY_ITEM_ID
, SALES_QTY
, SALES_AMT
FROM OZF.OZF_ORDER_SALES_SUMRY_MV#;
|
|
|