[Home] [Help] [Dependency Information]
Object Name: | QPR_PN_REQUEST_HDRS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|