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.OZF_SD_PRODUCTS_V

Object Details

Object Name:	OZF_SD_PRODUCTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Contains the product information

[View Source]

Columns

Name	Datatype	Length	Comments
REQUEST_HEADER_ID	NUMBER		Request header ID
PRODUCT_COST	NUMBER		Product unit cost
COST_LABEL	CHAR	(4)	Label
PRODUCT_COST_CURRENCY	VARCHAR2	(15)	Product cost currency
REQUESTED_DISCOUNT_TYPE	VARCHAR2	(30)	Requested discount type
REQUESTED_DISCOUNT_VALUE	NUMBER		Requested discount value
REQUEST_COST_LABEL	CHAR	(14)	Label indicating the Request cost
DISCOUNT_CURRENCY	VARCHAR2	(15)	Requested discount currency
END_CUSTOMER_PRICE_VALUE	NUMBER		End Customer Price value
END_CUSTOMER_PRICE_TYPE	VARCHAR2	(30)	End Customer Price type
RESALE_COST_LABEL	CHAR	(6)	Label
END_CUSTOMER_CURRENCY	VARCHAR2	(15)	End customer currency
REQUEST_LINE_ID	NUMBER		Request Line ID
DESIGN_WIN_NUMBER	VARCHAR2	(80)	Design win number
UNIT_OF_MEASUREMENT	VARCHAR2	(3)	Uinit of Measure
VENDOR_PRODUCT_CODE	VARCHAR2	(240)	Vendor product code
MAX_QUANTITY	NUMBER		Maximum quantity allowed
DIST_PRODUCT_CODE	VARCHAR2	(240)	Distributor product code
PRODUCT_LINE_TYPE	VARCHAR2	(30)	Distingush between product/product category
GLB_PRT_R_CLASS_CODE	CHAR	(16)	Partner Role Classification code
GLB_PRT_CLASS_CODE	CHAR	(12)	Partner classification code

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_HEADER_ID
,      PRODUCT_COST
,      COST_LABEL
,      PRODUCT_COST_CURRENCY
,      REQUESTED_DISCOUNT_TYPE
,      REQUESTED_DISCOUNT_VALUE
,      REQUEST_COST_LABEL
,      DISCOUNT_CURRENCY
,      END_CUSTOMER_PRICE_VALUE
,      END_CUSTOMER_PRICE_TYPE
,      RESALE_COST_LABEL
,      END_CUSTOMER_CURRENCY
,      REQUEST_LINE_ID
,      DESIGN_WIN_NUMBER
,      UNIT_OF_MEASUREMENT
,      VENDOR_PRODUCT_CODE
,      MAX_QUANTITY
,      DIST_PRODUCT_CODE
,      PRODUCT_LINE_TYPE
,      GLB_PRT_R_CLASS_CODE
,      GLB_PRT_CLASS_CODE
FROM APPS.OZF_SD_PRODUCTS_V;

Dependencies

[top of page]

APPS.OZF_SD_PRODUCTS_V references the following:

APPS: ENI_PROD_DEN_HRCHY_PARENTS_V; MTL_SYSTEM_ITEMS_B_KFV; OZF_SD_REQUEST_LINES_ALL

APPS.OZF_SD_PRODUCTS_V is not referenced by any database object