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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_ITEM	VARCHAR2	(1943)		Price List name concatenated with the item
NAME	VARCHAR2	(240)	Yes	Price List name
PRODUCT_ATTR_VALUE	VARCHAR2	(240)		product attribute value
CONCATENATED_SEGMENTS	VARCHAR2	(2000)		Concatenated value of the individual segments of the item key flexfield.
LIST_LINE_ID	NUMBER		Yes	List line id
OPERAND	NUMBER			list price of the item
PRODUCT_UOM_CODE	VARCHAR2	(3)		unit of measure
START_DATE_ACTIVE	DATE			effective from
END_DATE_ACTIVE	DATE			effective until
PRICE_BY_FORMULA_ID	NUMBER			price formula id

Query Text

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


SELECT LIST_ITEM
,      NAME
,      PRODUCT_ATTR_VALUE
,      CONCATENATED_SEGMENTS
,      LIST_LINE_ID
,      OPERAND
,      PRODUCT_UOM_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PRICE_BY_FORMULA_ID
FROM APPS.QP_PRICE_LIST_ITEMS_V;

Dependencies

[top of page]

APPS.QP_PRICE_LIST_ITEMS_V references the following:

APPS: FND_PROFILE - show dependent code; MTL_CATEGORIES_KFV; MTL_SYSTEM_ITEMS_KFV; QP_LIST_LINES; QP_PRICING_ATTRIBUTES; QP_SECU_LIST_HEADERS_VL; QP_UTIL - show dependent code
PUBLIC: DUAL

APPS.QP_PRICE_LIST_ITEMS_V is not referenced by any database object