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


VIEW: APPS.QPR_SR_OM_QUOTE_HEADERS_V

Object Details
Object Name: QPR_SR_OM_QUOTE_HEADERS_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 header


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.QPR_SR_OM_QUOTE_HEADERS_V references the following:

SchemaAPPS
ViewFND_APPLICATION_VL
ViewFND_CURRENCIES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
SynonymOE_ORDER_HEADERS_ALL
ViewOE_TRXT_TYPES_NOORGS_VL
PL/SQL PackageQPR_SR_UTIL - show dependent code
SynonymRA_SALESREPS_ALL
SynonymSO_LOOKUPS

APPS.QPR_SR_OM_QUOTE_HEADERS_V is not referenced by any database object