[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_QUOTE_HEADERS_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 headers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUOTE_HEADER_ID | NUMBER | Yes | Source header id | |
QUOTE_NUMBER | NUMBER | Yes | Source document number | |
QUOTE_CREATION_DATE | DATE | Yes | Creation date | |
QUOTE_VERSION | NUMBER | Yes | Version number | |
QUOTE_HEADER_SD | VARCHAR2 | (87) | Header short description | |
QUOTE_HEADER_LD | VARCHAR2 | (240) | Header long description | |
SOURCE_ID | NUMBER | Source id | ||
SOURCE_SD | CHAR | (14) | Source short description | |
SOURCE_LD | CHAR | (14) | Source long description | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | 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 | Sales representative id | ||
SALES_REP_NAME | VARCHAR2 | (240) | Sales representative name | |
SALES_REP_NUMBER | VARCHAR2 | (30) | Sales representative number | |
SALES_REP_EMAIL | VARCHAR2 | (240) | Sales representative 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 | Invoice to party id | ||
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 informations |
Cut, paste (and edit) the following text to query this object:
SELECT QUOTE_HEADER_ID
, QUOTE_NUMBER
, QUOTE_CREATION_DATE
, QUOTE_VERSION
, 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_QUOTE_HEADERS_V;
APPS.QPR_SR_QUOTE_HEADERS_V is not referenced by any database object
|
|
|