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_RESPONSE_HDRS

Object Details

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

This table stores the Response header data for Deal during negotiation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PN_RESPONSE_HDRS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESPONSE_HEADER_ID
SYS_IL0000458223C00011$$	LOB	UNIQUE	APPS_TS_TX_DATA
QPR_PN_RESPONSE_HDRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_HEADER_ID
QPR_PN_RESPONSE_HDRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VERSION_NUMBER
QPR_PN_RESPONSE_HDRS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
RESPONSE_HEADER_ID	NUMBER		Yes	Unique Identifier for the deal response header.
REQUEST_HEADER_ID	NUMBER		Yes	Unique Identifier for the request header to which the deal response belongs.
VERSION_NUMBER	NUMBER		Yes	Indicates the scenario number created for a request header.
OWNER_ID	NUMBER		Yes	Unique Identifier of the owner of the deal.
RESPONSE_STATUS	VARCHAR2	(30)	Yes	Indicates the status of the response. Takes values 'ACCEPT', 'APPROVED','APPROVE_PROCESS','APPROVE_REQ','PENDING_APPROVAL','PEND_ACCEPT_APPROVE','PEND_ACCEPT_NO_APPROVE','REJECT'
PARENT_RESPONSE_ID	NUMBER			Indicates the header id of the response from which a new scenario was created.
DEAL_LAST_UPDATED_BY	NUMBER			Indicates the user who last updated the response.
DEAL_LAST_UPDATE_DATE	DATE			Indicates the last update date
DEAL_HEADER_SCORE	NUMBER			Score for the response derived from the line scores.
DESCRIPTION	VARCHAR2	(100)		Description
RESPONSE_OUTPUT	CLOB	(4000)		Not Currently Used
COMMENTS	VARCHAR2	(2000)		User comments
BOOKMARK_FLAG	VARCHAR2	(1)		Indicates if book marking is done on this response for easy accessbility. Takes values 'Y' or 'N'.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		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 RESPONSE_HEADER_ID
,      REQUEST_HEADER_ID
,      VERSION_NUMBER
,      OWNER_ID
,      RESPONSE_STATUS
,      PARENT_RESPONSE_ID
,      DEAL_LAST_UPDATED_BY
,      DEAL_LAST_UPDATE_DATE
,      DEAL_HEADER_SCORE
,      DESCRIPTION
,      RESPONSE_OUTPUT
,      COMMENTS
,      BOOKMARK_FLAG
,      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_RESPONSE_HDRS;

Dependencies

[top of page]

QPR.QPR_PN_RESPONSE_HDRS does not reference any database object

QPR.QPR_PN_RESPONSE_HDRS is referenced by following:

QPR: QPR_PN_RESPONSE_HDRS#