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: QP.QP_LIMIT_TRANSACTIONS

Object Details

Object Name:	QP_LIMIT_TRANSACTIONS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_LIMIT_TRANSACTIONS
Subobject Name:
Status:	VALID

This table holds details of all the transactions which consumed or increased the available balance on all the limits.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_LIMIT_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_REQUEST_CODE LIMIT_BALANCE_ID LIST_HEADER_ID LIST_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LIMIT_BALANCE_ID	NUMBER		Yes	Identifies the limit balance to which the transaction has been made.
CREATION_DATE	DATE		Yes	Standard WHO Column.
CREATED_BY	NUMBER		Yes	Standard WHO Column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column.
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column.
PROGRAM_ID	NUMBER			Standard WHO Column.
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column.
REQUEST_ID	NUMBER			Standard WHO Column.
LIST_HEADER_ID	NUMBER		Yes	Identifies the List Header - required for processing List Header limits across Phases.
LIST_LINE_ID	NUMBER		Yes	Identifies the List Line - required for processing List Header limits across Phases.
PRICE_REQUEST_DATE	DATE		Yes	Date the transaction was applied to the limit.
PRICE_REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the type of request from which the transaction originated. The request type will be unique for each transaction that is priced and hence identifies the application from which the transaction originated.
PRICE_REQUEST_CODE	VARCHAR2	(240)	Yes	Pricing transaction code.
AMOUNT	NUMBER		Yes	Amount of limit units.
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield Segment/s
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield Segment/s
PRICING_PHASE_ID	NUMBER			Column to store the pricing_phase_id of the modifier corresponding to the limit transaction record.
REASON_CODE	VARCHAR2	(50)		Reason Code.
REASON_TEXT	VARCHAR2	(2000)		Reason to justify adjusting transactions.
MANUAL_FLAG	VARCHAR2	(1)		Yes : for adustments created manually, No: otherwise.

Query Text

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


SELECT LIMIT_BALANCE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      PRICE_REQUEST_DATE
,      PRICE_REQUEST_TYPE_CODE
,      PRICE_REQUEST_CODE
,      AMOUNT
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_PHASE_ID
,      REASON_CODE
,      REASON_TEXT
,      MANUAL_FLAG
FROM QP.QP_LIMIT_TRANSACTIONS;

Dependencies

[top of page]

QP.QP_LIMIT_TRANSACTIONS does not reference any database object

QP.QP_LIMIT_TRANSACTIONS is referenced by following:

QP: QP_LIMIT_TRANSACTIONS#