VIEW: APPS.PJM_BORROW_PAYBACK_DETAIL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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