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: PJM.PJM_BORROW_PAYBACKS

Object Details

Object Name:	PJM_BORROW_PAYBACKS
Object Type:	TABLE
Owner:	PJM
FND Design Data:	PJM.PJM_BORROW_PAYBACKS
Subobject Name:
Status:	VALID

PJM_BORROW_PAYBACKS captures allocation of inter-project payback transactions to outstanding borrow transactions. Information stored in this table is used by the Cost Processor to determine proper accounting entries for the payback transaction. Payback quantity is allocated to borrow transactions using a FIFO algorithm.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJM_BORROW_PAYBACKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BORROW_TRANSACTION_ID PAYBACK_TRANSACTION_ID
PJM_BORROW_PAYBACKS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BORROW_PROJECT_ID
PJM_BORROW_PAYBACKS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LENDING_PROJECT_ID
PJM_BORROW_PAYBACKS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYBACK_TRANSACTION_ID

Columns

Name	Datatype	Mandatory	Comments
PAYBACK_TRANSACTION_ID	NUMBER	Yes	Transaction unique identifier for inter-project payback transaction
BORROW_TRANSACTION_ID	NUMBER	Yes	Transaction unique identifier for inter-project borrow transaction
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
REQUEST_ID	NUMBER		Extended Who column
PROGRAM_APPLICATION_ID	NUMBER		Extended Who column
PROGRAM_ID	NUMBER		Extended Who column
PROGRAM_UPDATE_DATE	DATE		Extended Who column
PAYBACK_QUANTITY	NUMBER	Yes	Quantity allocated to this borrow transaction
BORROW_PROJECT_ID	NUMBER	Yes	Unique identifier for borrowing project
BORROW_TASK_ID	NUMBER		Unique identifier for borrowing task
LENDING_PROJECT_ID	NUMBER	Yes	Unique identifier for lending project
LENDING_TASK_ID	NUMBER		Unique identifier for lending task

Query Text

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


SELECT PAYBACK_TRANSACTION_ID
,      BORROW_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PAYBACK_QUANTITY
,      BORROW_PROJECT_ID
,      BORROW_TASK_ID
,      LENDING_PROJECT_ID
,      LENDING_TASK_ID
FROM PJM.PJM_BORROW_PAYBACKS;

Dependencies

[top of page]

PJM.PJM_BORROW_PAYBACKS does not reference any database object

PJM.PJM_BORROW_PAYBACKS is referenced by following:

APPS: PJM_BORROW_PAYBACKS