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_CRMINTEG_PRICELIST_V

Object Details

Object Name:	QP_CRMINTEG_PRICELIST_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_HEADER_ID	NUMBER		Yes	list_header_id of price list
NAME	VARCHAR2	(240)	Yes	Name of pricelist
CURRENCY_CODE	VARCHAR2	(30)		Currency of pricelist
HEADER_START_DATE	DATE			Header start date
HEADER_END_DATE	DATE			Header end date
ORIG_ORG_ID	NUMBER			Organization Id
OU_NAME	VARCHAR2	(240)		Operating Unit Name
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship method code
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Frieght Term code
DESCRIPTION	VARCHAR2	(2000)		Description
LIST_LINE_ID	NUMBER		Yes	list_line_id of pricelist line
LINE_START_DATE	DATE			Line start date
LINE_END_DATE	DATE			Line end date
PRODUCT_ATTR_VALUE	VARCHAR2	(240)		product attribute value
PRODUCT_UOM_CODE	VARCHAR2	(3)		Product uom code
OPERAND	NUMBER			Operand
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory_item_id of item
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Concatenaged segment
ORGANIZATION_ID	NUMBER		Yes	Org id
ORGANIZATION_CODE	VARCHAR2	(3)		Org code
ACTIVE_FLAG	VARCHAR2	(1)		Active Flag

Query Text

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


SELECT LIST_HEADER_ID
,      NAME
,      CURRENCY_CODE
,      HEADER_START_DATE
,      HEADER_END_DATE
,      ORIG_ORG_ID
,      OU_NAME
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      DESCRIPTION
,      LIST_LINE_ID
,      LINE_START_DATE
,      LINE_END_DATE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      OPERAND
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ACTIVE_FLAG
FROM APPS.QP_CRMINTEG_PRICELIST_V;

Dependencies

[top of page]

APPS.QP_CRMINTEG_PRICELIST_V references the following:

APPS: FND_PROFILE - show dependent code; HR_OPERATING_UNITS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV; QP_LIST_HEADERS_VL; QP_LIST_LINES; QP_PRICING_ATTRIBUTES; QP_RLTD_MODIFIERS

APPS.QP_CRMINTEG_PRICELIST_V is not referenced by any database object