eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CST_BIS_MARGIN_ANALYSIS_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

APPS.CST_BIS_MARGIN_ANALYSIS_V references the following:

APPS: AR_LOOKUPS; CST_BIS_MARGIN_BUILD; CST_BIS_MARGIN_SUMMARY; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_CATEGORIES_KFV; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; MTL_SYSTEM_ITEMS_KFV; RA_SALESREPS_ALL; RA_TERRITORIES; SO_LOOKUPS

APPS.CST_BIS_MARGIN_ANALYSIS_V is not referenced by any database object