[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_OM_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.
Order management deal source view - Order header
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 |
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;
APPS.QPR_SR_OM_QUOTE_HEADERS_V is not referenced by any database object
|
|
|