[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PJM.PJM_BORROW_TRANSACTIONS does not reference any database object
PJM.PJM_BORROW_TRANSACTIONS is referenced by following:
|
|
|