DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.QPR_SR_OM_QUOTE_LINES_V

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


Order management deal source view - Order line


[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 VARCHAR2 (4000)
Line number
ORG_ID NUMBER

Organization Id
ORG_NAME VARCHAR2 (240) Yes Organization
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

Model line id
UOM_CODE VARCHAR2 (3)
UOM code
UOM_SD VARCHAR2 (25) Yes UOM
UOM_LD VARCHAR2 (50)
UOM
QUANTITY NUMBER

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 (240)
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
,      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_OM_QUOTE_LINES_V;

Dependencies

[top of page]

APPS.QPR_SR_OM_QUOTE_LINES_V references the following:

SchemaAPPS
ViewFND_APPLICATION_VL
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_PROFILE - show dependent code
ViewHR_ALL_ORGANIZATION_UNITS_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
ViewMTL_SYSTEM_ITEMS_VL
ViewMTL_UNITS_OF_MEASURE_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
PL/SQL PackageOE_ORDER_MISC_PUB - show dependent code
ViewOE_SHIP_METHODS_V
PL/SQL PackageQPR_SR_UTIL - show dependent code
ViewRA_TERMS_VL

APPS.QPR_SR_OM_QUOTE_LINES_V is not referenced by any database object