[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_QUOTE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Oracle quoting deal source view - Quote lines
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 |
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;
APPS.QPR_SR_QUOTE_LINES_V is not referenced by any database object
|
|
|