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]

TABLE: QPR.QPR_PN_REQUEST_HDRS_B

Object Details

Object Name:	QPR_PN_REQUEST_HDRS_B
Object Type:	TABLE
Owner:	QPR
Subobject Name:
Status:	VALID

This table stores the Request Data for Deal Negotiation

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PN_REQUEST_HDRS_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_HEADER_ID
QPR_PN_REQUEST_HDRS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_REF_HDR_SHORT_DESC
QPR_PN_REQUEST_HDRS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_REP_SHORT_DESC
QPR_PN_REQUEST_HDRS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_CREATION_DATE

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'
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.
CUSTOMER_ID	NUMBER		Yes	Customer Identifier
PN_INT_HEADER_ID	NUMBER			Unique Identifier of the header record in the interface table.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
SOURCE_ID	NUMBER			Identifier of the deal source.
SOURCE_REF_HDR_ID	NUMBER		Yes	Identifier of the header as in the source instance from which it is sourced.
SALES_CHANNEL_CODE	VARCHAR2	(240)		Sales Channel Identifier
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_ID	NUMBER			Sales Representative Identifier
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.
PAYMENT_TERMS_ID	NUMBER			Payment Term Identifier.
DEAL_CREATION_DATE	DATE			Date on which deal is created.
DEAL_EXPIRY_DATE	DATE			Date on which deal expires.
INVOICE_TO_PARTY_SITE_ID	NUMBER			Identifier of the invoice-to site.
INVOICE_TO_PARTY_SITE_ADDRESS	VARCHAR2	(4000)		Holds the addresses of the invoice-to site
CURRENCY_SHORT_DESC	VARCHAR2	(240)		Currency code Short Description
CURRENCY_LONG_DESC	VARCHAR2	(240)		Currency code long description
SOURCE_SHORT_DESC	VARCHAR2	(240)		Source instance name
SOURCE_LONG_DESC	VARCHAR2	(240)		Long Description about Source instance
SOURCE_REF_HDR_SHORT_DESC	VARCHAR2	(240)		Short Description about the source header
SOURCE_REF_HDR_LONG_DESC	VARCHAR2	(240)		Long description about the source header
CUSTOMER_SHORT_DESC	VARCHAR2	(240)		Customer Short Description
CUSTOMER_LONG_DESC	VARCHAR2	(240)		Customer Long Description
SALES_REP_EMAIL	VARCHAR2	(240)		Email address of the sales representative
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 term short description
PAYMENT_TERMS_LONG_DESC	VARCHAR2	(240)		Payment Term Long description
SIMULATION_FLAG	VARCHAR2	(1)		Indicates if values are simulated or actual. Takes the values 'Y'/'N'.
COMMENTS	VARCHAR2	(2000)		Comments about the deal
MEASURE1_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE2_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE3_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE4_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE5_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE6_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE7_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE8_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE9_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE10_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE1_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE2_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE3_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE4_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE5_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE6_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE7_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE8_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE9_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE10_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
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
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applicaitons Concurrent Program Login ID
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned the concurrent program.
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned the concurrent program

Query Text

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


SELECT REQUEST_HEADER_ID
,      REQUEST_STATUS
,      CUSTOMER_SK
,      CUSTOMER_ID
,      PN_INT_HEADER_ID
,      INSTANCE_ID
,      SOURCE_ID
,      SOURCE_REF_HDR_ID
,      SALES_CHANNEL_CODE
,      SALES_CHANNEL_SK
,      SALES_REP_ID
,      SALES_REP_SK
,      PAYMENT_TERMS_ID
,      DEAL_CREATION_DATE
,      DEAL_EXPIRY_DATE
,      INVOICE_TO_PARTY_SITE_ID
,      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_EMAIL
,      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
,      SIMULATION_FLAG
,      COMMENTS
,      MEASURE1_NUMBER
,      MEASURE2_NUMBER
,      MEASURE3_NUMBER
,      MEASURE4_NUMBER
,      MEASURE5_NUMBER
,      MEASURE6_NUMBER
,      MEASURE7_NUMBER
,      MEASURE8_NUMBER
,      MEASURE9_NUMBER
,      MEASURE10_NUMBER
,      MEASURE1_CHAR
,      MEASURE2_CHAR
,      MEASURE3_CHAR
,      MEASURE4_CHAR
,      MEASURE5_CHAR
,      MEASURE6_CHAR
,      MEASURE7_CHAR
,      MEASURE8_CHAR
,      MEASURE9_CHAR
,      MEASURE10_CHAR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM QPR.QPR_PN_REQUEST_HDRS_B;

Dependencies

[top of page]

QPR.QPR_PN_REQUEST_HDRS_B does not reference any database object

QPR.QPR_PN_REQUEST_HDRS_B is referenced by following:

QPR: QPR_PN_REQUEST_HDRS_B#