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_QUOTE_LINES_V

Object Details

Object Name:	QPR_SR_QUOTE_LINES_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.

Oracle quoting deal source view - Quote lines

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_HEADER_ID	NUMBER		Yes	Source header id
QUOTE_LINE_ID	NUMBER		Yes	Source line id
SOURCE_ID	NUMBER			Source id
QUOTE_LINE_NUMBER	NUMBER			Quote line number
LINE_START_DATE	DATE			Start date
LINE_END_DATE	DATE			End date
ORG_ID	NUMBER			Organization id
ORG_NAME	VARCHAR2	(240)		Organization name
INVENTORY_ITEM_ID	NUMBER		Yes	Item id
INVENTORY_ITEM	VARCHAR2	(40)		Item
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
ITEM_TYPE_CODE	VARCHAR2	(30)		Item type
TOP_MODEL_LINE_ID	NUMBER			Top model line id
UOM_CODE	VARCHAR2	(3)	Yes	UOM Code
UOM_SD	VARCHAR2	(25)	Yes	UOM
UOM_LD	VARCHAR2	(50)		UOM
QUANTITY	NUMBER		Yes	Quantity
CURRENCY_CODE	VARCHAR2	(15)		Currency code
CURRENCY_SD	VARCHAR2	(80)	Yes	Currency
CURRENCY_LD	VARCHAR2	(240)		Currency
LINE_LIST_PRICE	NUMBER			List price
LINE_QUOTE_PRICE	NUMBER			Quote price
LINE_ADJUSTMENT_AMT	NUMBER			Adjustment amount
LINE_ADJUSTMENT_PERC	NUMBER			Adjustment percentage
PAYMENT_TERM_ID	NUMBER			Payment term id
PAYMENT_TERM_SD	VARCHAR2	(15)		Payment term
PAYMENT_TERM_LD	VARCHAR2	(240)		Payment term
GEOGRAPHY_ID	NUMBER			Geography id
GEOGRAPHY_SD	VARCHAR2	(432)		Geography
GEOGRAPHY_LD	VARCHAR2	(432)		Geography
COMPETITOR_NAME	VARCHAR2	(240)		Competitor name
COMPETITOR_PRICE	VARCHAR2	(240)		Competitor price
COMMENTS	VARCHAR2	(0)		Comments
ADDITIONAL_INFORMATION	VARCHAR2	(0)		Additional information
SHIP_METHOD_CODE	VARCHAR2	(30)		Ship method code
SHIP_METHOD_SD	VARCHAR2	(80)		Ship method
SHIP_METHOD_LD	VARCHAR2	(80)		Ship method
FREIGHT_CHARGES	VARCHAR2	(0)		Freight charge

Query Text

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


SELECT QUOTE_HEADER_ID
,      QUOTE_LINE_ID
,      SOURCE_ID
,      QUOTE_LINE_NUMBER
,      LINE_START_DATE
,      LINE_END_DATE
,      ORG_ID
,      ORG_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM
,      ITEM_DESCRIPTION
,      ITEM_TYPE_CODE
,      TOP_MODEL_LINE_ID
,      UOM_CODE
,      UOM_SD
,      UOM_LD
,      QUANTITY
,      CURRENCY_CODE
,      CURRENCY_SD
,      CURRENCY_LD
,      LINE_LIST_PRICE
,      LINE_QUOTE_PRICE
,      LINE_ADJUSTMENT_AMT
,      LINE_ADJUSTMENT_PERC
,      PAYMENT_TERM_ID
,      PAYMENT_TERM_SD
,      PAYMENT_TERM_LD
,      GEOGRAPHY_ID
,      GEOGRAPHY_SD
,      GEOGRAPHY_LD
,      COMPETITOR_NAME
,      COMPETITOR_PRICE
,      COMMENTS
,      ADDITIONAL_INFORMATION
,      SHIP_METHOD_CODE
,      SHIP_METHOD_SD
,      SHIP_METHOD_LD
,      FREIGHT_CHARGES
FROM APPS.QPR_SR_QUOTE_LINES_V;

Dependencies

[top of page]

APPS.QPR_SR_QUOTE_LINES_V references the following:

APPS: ASO_PAYMENTS; ASO_QUOTE_HEADERS_ALL; ASO_QUOTE_LINES_ALL; ASO_QUOTE_LINE_DETAILS; ASO_SHIPMENTS; FND_APPLICATION_VL; FND_CURRENCIES_VL; FND_PROFILE - show dependent code; HR_ALL_ORGANIZATION_UNITS_VL; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE_VL; OE_SHIP_METHODS_V; QPR_SR_UTIL - show dependent code; RA_TERMS_VL

APPS.QPR_SR_QUOTE_LINES_V is not referenced by any database object