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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Order management deal source view - Order header

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_HEADER_ID	NUMBER		Yes	Source header id
QUOTE_NUMBER	NUMBER			Order number
QUOTE_CREATION_DATE	DATE			Creation date
QUOTE_VERSION	NUMBER		Yes	Version number
ORDER_TYPE_NAME	VARCHAR2	(30)	Yes	Order type
QUOTE_HEADER_SD	VARCHAR2	(87)		Header short description
QUOTE_HEADER_LD	VARCHAR2	(240)		Header long description
SOURCE_ID	NUMBER			Source id
SOURCE_SD	CHAR	(23)		Source description
SOURCE_LD	CHAR	(23)		Source description
CURRENCY_CODE	VARCHAR2	(15)		Currency code
CURRENCY_SD	VARCHAR2	(80)	Yes	Currency
CURRENCY_LD	VARCHAR2	(240)		Currency
CUST_ID	NUMBER			Customer Id
CUST_ACC_NUMBER	VARCHAR2	(30)	Yes	Customer account number
CUST_ACC_NAME	VARCHAR2	(240)		Customer name
SALES_REP_ID	NUMBER	(15)		Sales representative
SALES_REP_NAME	VARCHAR2	(240)		Sales rep name
SALES_REP_NUMBER	VARCHAR2	(30)		Sales rep number
SALES_REP_EMAIL	VARCHAR2	(240)		Sales rep e-mail address.
SALES_CHANNEL_CODE	VARCHAR2	(30)		Sales channel code
SALES_CHANNEL_SD	VARCHAR2	(80)		Sales channel
SALES_CHANNEL_LD	VARCHAR2	(240)		Sales channel
INV_TO_PARTY_SITE_ID	NUMBER	(15)		Invoice to party
INV_TO_PARTY_SITE_ADDR	VARCHAR2	(545)		Invoice to party address
FREIGHT_TERMS_CODE	VARCHAR2	(30)		Freight terms code
FREIGHT_TERMS_SD	VARCHAR2	(80)		Freight terms
FREIGHT_TERMS_LD	VARCHAR2	(240)		Freight terms
QUOTE_EXPIRATION_DATE	DATE			Expiry date
COMMENTS	VARCHAR2	(240)		Comments
ADDITIONAL_INFORMATION	VARCHAR2	(0)		Additional information

Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_NUMBER
,      QUOTE_CREATION_DATE
,      QUOTE_VERSION
,      ORDER_TYPE_NAME
,      QUOTE_HEADER_SD
,      QUOTE_HEADER_LD
,      SOURCE_ID
,      SOURCE_SD
,      SOURCE_LD
,      CURRENCY_CODE
,      CURRENCY_SD
,      CURRENCY_LD
,      CUST_ID
,      CUST_ACC_NUMBER
,      CUST_ACC_NAME
,      SALES_REP_ID
,      SALES_REP_NAME
,      SALES_REP_NUMBER
,      SALES_REP_EMAIL
,      SALES_CHANNEL_CODE
,      SALES_CHANNEL_SD
,      SALES_CHANNEL_LD
,      INV_TO_PARTY_SITE_ID
,      INV_TO_PARTY_SITE_ADDR
,      FREIGHT_TERMS_CODE
,      FREIGHT_TERMS_SD
,      FREIGHT_TERMS_LD
,      QUOTE_EXPIRATION_DATE
,      COMMENTS
,      ADDITIONAL_INFORMATION
FROM APPS.QPR_SR_OM_QUOTE_HEADERS_V;

Dependencies

[top of page]

APPS.QPR_SR_OM_QUOTE_HEADERS_V references the following:

APPS: FND_APPLICATION_VL; FND_CURRENCIES_VL; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTY_SITES; OE_ORDER_HEADERS_ALL; OE_TRXT_TYPES_NOORGS_VL; QPR_SR_UTIL - show dependent code; RA_SALESREPS_ALL; SO_LOOKUPS

APPS.QPR_SR_OM_QUOTE_HEADERS_V is not referenced by any database object