eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QPR_PN_REQUEST_HDRS_VL

Object Details

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

This is a view of QPR_PN_REQUEST_HDRS_B and QPR_PN_REQUEST_HDRS_TL.
Displays the details about deal request and translated columns of deal request in the local language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_HEADER_ID	NUMBER		Yes	Unique Identifier of the request header
REQUEST_STATUS	VARCHAR2	(30)		Status of the request header. Takes Values 'ACTIVE', 'CLOSED', 'CANCELLED'
REFERENCE_NAME	VARCHAR2	(240)	Yes	Unique name for the request header derived by concatenating the source_short_desc and source_ref_hdr_short_desc.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
CUSTOMER_SK	VARCHAR2	(240)		Surrogate Key for Customer dimension dervied from Customer_id. This is used to identify a customer dimension member in the datamart.
SALES_CHANNEL_SK	VARCHAR2	(240)		Surrogate Key for Sales Channel dimension dervied from sales_channel_code. This is used to identify a Sales Channel dimension member in the datamart.
SALES_REP_SK	VARCHAR2	(240)		Surrogate Key for Sales Representative dimension dervied from sales_rep_id. This is used to identify a Sales representative dimension member in the datamart.
PN_INT_HEADER_ID	NUMBER			Surrogate Key for Sales Representative dimension dervied from sales_rep_id. This is used to identify a Sales representative dimension member in the datamart.
SOURCE_ID	NUMBER			Identifier of the deal source.
SOURCE_REF_HDR_ID	NUMBER		Yes	Identifier of the Header as in the source instance.
CUSTOMER_ID	NUMBER		Yes	Customer Identifier
SALES_REP_ID	NUMBER			Sales Representative Identifier
PAYMENT_TERMS_ID	NUMBER			Payment Term Identifier
INVOICE_TO_PARTY_SITE_ID	NUMBER			Identifier of invoice-to site
SALES_REP_EMAIL	VARCHAR2	(240)		Email address of the sales representative
SALES_CHANNEL_CODE	VARCHAR2	(240)		Sales Channel Identifier
DEAL_EXPIRY_DATE	DATE			Date on which deal expires
DEAL_CREATION_DATE	DATE			Date on which deal was created in the source
INVOICE_TO_PARTY_SITE_ADDRESS	VARCHAR2	(4000)		Address of the invoice-to site
CURRENCY_SHORT_DESC	VARCHAR2	(240)		Currency short Description
CURRENCY_LONG_DESC	VARCHAR2	(240)		Currency Long Descritpion
SOURCE_SHORT_DESC	VARCHAR2	(240)		Source instance name
SOURCE_LONG_DESC	VARCHAR2	(240)		Long description about the source instance
SOURCE_REF_HDR_SHORT_DESC	VARCHAR2	(240)		Short description about Source reference header
SOURCE_REF_HDR_LONG_DESC	VARCHAR2	(240)		Long description about source reference header
CUSTOMER_SHORT_DESC	VARCHAR2	(240)		Customer Short description
CUSTOMER_LONG_DESC	VARCHAR2	(240)		Customer Long description
SALES_REP_SHORT_DESC	VARCHAR2	(240)		Sales Representative short description
SALES_REP_LONG_DESC	VARCHAR2	(240)		Sales Representative long description
SALES_CHANNEL_SHORT_DESC	VARCHAR2	(240)		Sales Channel short description
SALES_CHANNEL_LONG_DESC	VARCHAR2	(240)		Sales Channel Long Description
FREIGHT_TERMS_SHORT_DESC	VARCHAR2	(240)		Not currently used
FREIGHT_TERMS_LONG_DESC	VARCHAR2	(240)		Not Currently used
PAYMENT_TERMS_SHORT_DESC	VARCHAR2	(240)		Payment Terms short description
PAYMENT_TERMS_LONG_DESC	VARCHAR2	(240)		Payment terms long description
COMMENTS	VARCHAR2	(2000)		Comments about the deal
SIMULATION_FLAG	VARCHAR2	(1)		Indicates if the values are simulated or actual. Takes values 'Y'/'N'.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_HEADER_ID
,      REQUEST_STATUS
,      REFERENCE_NAME
,      INSTANCE_ID
,      CUSTOMER_SK
,      SALES_CHANNEL_SK
,      SALES_REP_SK
,      PN_INT_HEADER_ID
,      SOURCE_ID
,      SOURCE_REF_HDR_ID
,      CUSTOMER_ID
,      SALES_REP_ID
,      PAYMENT_TERMS_ID
,      INVOICE_TO_PARTY_SITE_ID
,      SALES_REP_EMAIL
,      SALES_CHANNEL_CODE
,      DEAL_EXPIRY_DATE
,      DEAL_CREATION_DATE
,      INVOICE_TO_PARTY_SITE_ADDRESS
,      CURRENCY_SHORT_DESC
,      CURRENCY_LONG_DESC
,      SOURCE_SHORT_DESC
,      SOURCE_LONG_DESC
,      SOURCE_REF_HDR_SHORT_DESC
,      SOURCE_REF_HDR_LONG_DESC
,      CUSTOMER_SHORT_DESC
,      CUSTOMER_LONG_DESC
,      SALES_REP_SHORT_DESC
,      SALES_REP_LONG_DESC
,      SALES_CHANNEL_SHORT_DESC
,      SALES_CHANNEL_LONG_DESC
,      FREIGHT_TERMS_SHORT_DESC
,      FREIGHT_TERMS_LONG_DESC
,      PAYMENT_TERMS_SHORT_DESC
,      PAYMENT_TERMS_LONG_DESC
,      COMMENTS
,      SIMULATION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.QPR_PN_REQUEST_HDRS_VL;

Dependencies

[top of page]

APPS.QPR_PN_REQUEST_HDRS_VL references the following:

APPS: QPR_PN_REQUEST_HDRS_B; QPR_PN_REQUEST_HDRS_TL

APPS.QPR_PN_REQUEST_HDRS_VL is referenced by following:

APPS: QPR_WKFL_UTIL - show dependent code