[Home] [Help] [Dependency Information]
Object Name: | ICX_MARGIN_ANALYSIS# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUILD_ID | NUMBER | Yes | ||
CUSTOMER_ID | NUMBER | Yes | ||
PRIMARY_SALESREP_ID | NUMBER | Yes | ||
TERRITORY_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
PARENT_INVENTORY_ITEM_ID | NUMBER | |||
ORG_ID | NUMBER | |||
SOLD_TO_CUSTOMER_NAME | VARCHAR2 | (50) | ||
PERIOD | VARCHAR2 | (3) | Yes | |
INVOICED_AMOUNT | NUMBER | |||
COGS_AMOUNT | NUMBER | |||
MARGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BUILD_ID
, CUSTOMER_ID
, PRIMARY_SALESREP_ID
, TERRITORY_ID
, INVENTORY_ITEM_ID
, PARENT_INVENTORY_ITEM_ID
, ORG_ID
, SOLD_TO_CUSTOMER_NAME
, PERIOD
, INVOICED_AMOUNT
, COGS_AMOUNT
, MARGIN
FROM ICX.ICX_MARGIN_ANALYSIS#;
|
|
|