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

Object Details

Object Name:	QPFV_PRICE_LISTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QPFV_PRICE_LISTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view gives information about Standard and Agreement Price list headers.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(240)	Yes
ROUNDING_FACTOR	NUMBER
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
COMMENTS	VARCHAR2	(2000)
ACTIVE_FLAG	VARCHAR2	(1)
DESCRIPTION	VARCHAR2	(2000)
LIST_TYPE_CODE	VARCHAR2	(30)	Yes
_LA:LIST_TYPE_CODE	CHAR	(55)
CURRENCY_CODE	VARCHAR2	(30)
CURRENCY_NAME	VARCHAR2	(80)	Yes	This is the name of currency code.
SOURCE_SYSTEM_CODE	VARCHAR2	(30)
_LA:SOURCE_SYSTEM_CODE	CHAR	(58)
SHIP_METHOD_CODE	VARCHAR2	(30)
SHIP_METHOD_NAME	VARCHAR2	(80)		This is the name of the ship method code.
FREIGHT_TERMS_CODE	VARCHAR2	(30)
FREIGHT_TERMS_NAME	VARCHAR2	(80)		This is the name of the freight terms code.
LIST_HEADER_ID	NUMBER		Yes
TERMS_ID	NUMBER
PAYMENT_NAME	VARCHAR2	(15)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
_DF	CHAR	(25)		Descriptive Flexfield column values of qp_list_headers_b table.
ORIG_SYSTEM_HEADER_REF	VARCHAR2	(50)
CURRENCY_HEADER_ID	NUMBER
CURRENCY_CONVERSION_LIST	VARCHAR2	(240)
PTE_CODE	VARCHAR2	(30)
_LA:PTE_CODE	CHAR	(46)
LIST_SOURCE_CODE	VARCHAR2	(30)
ORIG_ORG_ID	NUMBER
GLOBAL_FLAG	VARCHAR2	(1)
SHAREABLE_FLAG	VARCHAR2	(1)
LOCKED_FROM_LIST_HEADER_ID	NUMBER
LOCKED_FROM_PRICE_LIST	VARCHAR2	(240)
SOLD_TO_ORG_ID	NUMBER
CUSTOMER_NAME	VARCHAR2	(360)
CUSTOMER_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT NAME
,      ROUNDING_FACTOR
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COMMENTS
,      ACTIVE_FLAG
,      DESCRIPTION
,      LIST_TYPE_CODE
,      _LA:LIST_TYPE_CODE
,      CURRENCY_CODE
,      CURRENCY_NAME
,      SOURCE_SYSTEM_CODE
,      _LA:SOURCE_SYSTEM_CODE
,      SHIP_METHOD_CODE
,      SHIP_METHOD_NAME
,      FREIGHT_TERMS_CODE
,      FREIGHT_TERMS_NAME
,      LIST_HEADER_ID
,      TERMS_ID
,      PAYMENT_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _DF
,      ORIG_SYSTEM_HEADER_REF
,      CURRENCY_HEADER_ID
,      CURRENCY_CONVERSION_LIST
,      PTE_CODE
,      _LA:PTE_CODE
,      LIST_SOURCE_CODE
,      ORIG_ORG_ID
,      GLOBAL_FLAG
,      SHAREABLE_FLAG
,      LOCKED_FROM_LIST_HEADER_ID
,      LOCKED_FROM_PRICE_LIST
,      SOLD_TO_ORG_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
FROM APPS.QPFV_PRICE_LISTS;

Dependencies

[top of page]

APPS.QPFV_PRICE_LISTS references the following:

APPS: FND_CURRENCIES_VL; HZ_CUST_ACCOUNTS; HZ_PARTIES; OE_FRGHT_TERMS_ACTIVE_V; OE_SHIP_METHODS_V; QP_CURRENCY_LISTS_TL; QP_LIST_HEADERS_B; QP_LIST_HEADERS_TL; RA_TERMS

APPS.QPFV_PRICE_LISTS is not referenced by any database object