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_TRANSACTIONS

Object Details

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

PJM_BORROW_TRANSACTIONS captures borrow transactions as they were entered into MTL_MATERIAL_TRANSACTIONS. In addition, this table maintains the outstanding loan quantity for each borrow transaction. One borrow transaction can be paid back by many payback transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJM_BORROW_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BORROW_TRANSACTION_ID
PJM_BORROW_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BORROW_PROJECT_ID
PJM_BORROW_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LENDING_PROJECT_ID
PJM_BORROW_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID
PJM_BORROW_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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
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
ORGANIZATION_ID	NUMBER		Yes	Inventory organization unique identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item unique identifier
REVISION	VARCHAR2	(3)		Revision of the item that is loaned
LOAN_QUANTITY	NUMBER		Yes	Original loan quantity
OUTSTANDING_QUANTITY	NUMBER		Yes	Outstanding loan quantity not yet paid back
LOAN_DATE	DATE		Yes	Loan date
SCHEDULED_PAYBACK_DATE	DATE			Scheduled payback date

Query Text

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


SELECT 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
,      BORROW_PROJECT_ID
,      BORROW_TASK_ID
,      LENDING_PROJECT_ID
,      LENDING_TASK_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      LOAN_QUANTITY
,      OUTSTANDING_QUANTITY
,      LOAN_DATE
,      SCHEDULED_PAYBACK_DATE
FROM PJM.PJM_BORROW_TRANSACTIONS;

Dependencies

[top of page]

PJM.PJM_BORROW_TRANSACTIONS does not reference any database object

PJM.PJM_BORROW_TRANSACTIONS is referenced by following:

PJM: PJM_BORROW_TRANSACTIONS#