View: PJM_BORROW_PAYBACK_DETAIL_V

Product:	PJM - Project Manufacturing
Description:	Inter-project borrow/payback details view
Implementation/DBA Data:	APPS.PJM_BORROW_PAYBACK_DETAIL_V

View Text

SELECT PBT.ORGANIZATION_ID
, PBT.INVENTORY_ITEM_ID
, PBT.REVISION
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, PBT.BORROW_TRANSACTION_ID
, TO_NUMBER(NULL)
, PBT.LOAN_DATE
, MMT.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, MTT.TRANSACTION_TYPE_NAME
, PBT.LOAN_QUANTITY
, PBT.OUTSTANDING_QUANTITY
, TO_NUMBER(NULL)
, PBT.SCHEDULED_PAYBACK_DATE
, DECODE(PBT.OUTSTANDING_QUANTITY
, 0
, TO_NUMBER(NULL)
, TRUNC(SYSDATE - PBT.LOAN_DATE))
FROM PJM_BORROW_TRANSACTIONS PBT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_TYPES MTT
WHERE MMT.TRANSACTION_ID = PBT.BORROW_TRANSACTION_ID
AND MTT.TRANSACTION_TYPE_ID = MMT.TRANSACTION_TYPE_ID UNION SELECT PBT.ORGANIZATION_ID
, PBT.INVENTORY_ITEM_ID
, PBT.REVISION
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, PBP.PAYBACK_TRANSACTION_ID
, PBP.BORROW_TRANSACTION_ID
, MMT.TRANSACTION_DATE
, MMT.TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME
, ' ' || MTT.TRANSACTION_TYPE_NAME
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PBP.PAYBACK_QUANTITY
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM PJM_BORROW_PAYBACKS PBP
, PJM_BORROW_TRANSACTIONS PBT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_TYPES MTT
WHERE PBT.BORROW_TRANSACTION_ID = PBP.BORROW_TRANSACTION_ID
AND MMT.TRANSACTION_ID = PBP.PAYBACK_TRANSACTION_ID
AND MTT.TRANSACTION_TYPE_ID = MMT.TRANSACTION_TYPE_ID

Columns