[Home] [Help] [Dependency Information]
Object Name: | CST_BIS_MARGIN_ANALYSIS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_BIS_MARGIN_ANALYSIS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_CATEGORY | VARCHAR2 | (163) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_PRIMARY_UOM | VARCHAR2 | (3) | ||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | ||
OPERATING_UNIT_NAME | VARCHAR2 | (240) | ||
SALES_ORDER_NUMBER | NUMBER | |||
SALES_ORDER_LINE_NUMBER | NUMBER | |||
TRANSACTION_DATE | DATE | |||
SALES_CHANNEL_NAME | VARCHAR2 | (80) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
SALES_REP_NAME | VARCHAR2 | (240) | ||
CUSTOMER_CLASS_NAME | VARCHAR2 | (80) | ||
TERRITORY_NAME | VARCHAR2 | (40) | ||
AREA_NAME | VARCHAR2 | (80) | ||
COUNTRY_NAME | VARCHAR2 | (80) | ||
REGION_NAME | VARCHAR2 | (80) | ||
YEAR | VARCHAR2 | (15) | ||
QUARTER | VARCHAR2 | (15) | ||
MONTH | VARCHAR2 | (15) | ||
YEAR_PERIOD_NUM | NUMBER | |||
QTR_PERIOD_NUM | NUMBER | |||
MONTH_PERIOD_NUM | NUMBER | |||
QTR_PERIOD_LABEL | VARCHAR2 | (48) | ||
MONTH_PERIOD_LABEL | VARCHAR2 | (46) | ||
QTR_PERIOD_SEQ | NUMBER | |||
MONTH_PERIOD_SEQ | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
QUANTITY_SHIPPED | NUMBER | |||
SALES_REVENUE_VALUE | NUMBER | |||
COST_OF_GOODS_SOLD_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCT_CATEGORY
, ITEM_NUMBER
, ITEM_PRIMARY_UOM
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_NAME
, SALES_ORDER_NUMBER
, SALES_ORDER_LINE_NUMBER
, TRANSACTION_DATE
, SALES_CHANNEL_NAME
, CUSTOMER_NAME
, SALES_REP_NAME
, CUSTOMER_CLASS_NAME
, TERRITORY_NAME
, AREA_NAME
, COUNTRY_NAME
, REGION_NAME
, YEAR
, QUARTER
, MONTH
, YEAR_PERIOD_NUM
, QTR_PERIOD_NUM
, MONTH_PERIOD_NUM
, QTR_PERIOD_LABEL
, MONTH_PERIOD_LABEL
, QTR_PERIOD_SEQ
, MONTH_PERIOD_SEQ
, QUANTITY_INVOICED
, QUANTITY_SHIPPED
, SALES_REVENUE_VALUE
, COST_OF_GOODS_SOLD_VALUE
FROM APPS.CST_BIS_MARGIN_ANALYSIS_V;
APPS.CST_BIS_MARGIN_ANALYSIS_V is not referenced by any database object
|
|
|