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.

VIEW: APPS.PJM_BORROW_PAYBACK_SUMMARY_V

Source

View Text - Preformatted


SELECT PBT.ORGANIZATION_ID , PBT.INVENTORY_ITEM_ID , PBT.REVISION , PBT.BORROW_PROJECT_ID , PJM_PROJECT.ALL_PROJ_IDTONUM(PBT.BORROW_PROJECT_ID) , PJM_PROJECT.ALL_PROJ_IDTONAME(PBT.BORROW_PROJECT_ID) , PBT.BORROW_TASK_ID , PJM_PROJECT.ALL_TASK_IDTONUM(PBT.BORROW_TASK_ID) , PJM_PROJECT.ALL_TASK_IDTONAME(PBT.BORROW_TASK_ID) , CG1.COST_GROUP_ID , CG1.COST_GROUP , PBT.LENDING_PROJECT_ID , PJM_PROJECT.ALL_PROJ_IDTONUM(PBT.LENDING_PROJECT_ID) , PJM_PROJECT.ALL_PROJ_IDTONAME(PBT.LENDING_PROJECT_ID) , PBT.LENDING_TASK_ID , PJM_PROJECT.ALL_TASK_IDTONUM(PBT.LENDING_TASK_ID) , PJM_PROJECT.ALL_TASK_IDTONAME(PBT.LENDING_TASK_ID) , CG2.COST_GROUP_ID , CG2.COST_GROUP , SUM(PBT.OUTSTANDING_QUANTITY) , SUM(DECODE(SIGN(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE) - 1), -1, PBT.OUTSTANDING_QUANTITY, 0)) , SUM(DECODE(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE), 1, PBT.OUTSTANDING_QUANTITY, 0)) , SUM(DECODE(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE), 2, PBT.OUTSTANDING_QUANTITY, 0)) , SUM(DECODE(SIGN(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE) - 2), 1, PBT.OUTSTANDING_QUANTITY, 0)) FROM PJM_BORROW_TRANSACTIONS PBT , PJM_PROJECT_PARAMETERS PP1 , PJM_PROJECT_PARAMETERS PP2 , CST_COST_GROUPS CG1 , CST_COST_GROUPS CG2 WHERE PP1.PROJECT_ID = PBT.BORROW_PROJECT_ID AND PP1.ORGANIZATION_ID = PBT.ORGANIZATION_ID AND PP2.PROJECT_ID = PBT.LENDING_PROJECT_ID AND PP2.ORGANIZATION_ID = PBT.ORGANIZATION_ID AND CG1.COST_GROUP_ID = NVL(PP1.COSTING_GROUP_ID,1) AND CG2.COST_GROUP_ID = NVL(PP2.COSTING_GROUP_ID,1) GROUP BY PBT.ORGANIZATION_ID , PBT.INVENTORY_ITEM_ID , PBT.REVISION , PBT.BORROW_PROJECT_ID , PBT.BORROW_TASK_ID , CG1.COST_GROUP_ID , CG1.COST_GROUP , PBT.LENDING_PROJECT_ID , PBT.LENDING_TASK_ID , CG2.COST_GROUP_ID , CG2.COST_GROUP

View Text - HTML Formatted

SELECT PBT.ORGANIZATION_ID
, PBT.INVENTORY_ITEM_ID
, PBT.REVISION
, PBT.BORROW_PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(PBT.BORROW_PROJECT_ID)
, PJM_PROJECT.ALL_PROJ_IDTONAME(PBT.BORROW_PROJECT_ID)
, PBT.BORROW_TASK_ID
, PJM_PROJECT.ALL_TASK_IDTONUM(PBT.BORROW_TASK_ID)
, PJM_PROJECT.ALL_TASK_IDTONAME(PBT.BORROW_TASK_ID)
, CG1.COST_GROUP_ID
, CG1.COST_GROUP
, PBT.LENDING_PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(PBT.LENDING_PROJECT_ID)
, PJM_PROJECT.ALL_PROJ_IDTONAME(PBT.LENDING_PROJECT_ID)
, PBT.LENDING_TASK_ID
, PJM_PROJECT.ALL_TASK_IDTONUM(PBT.LENDING_TASK_ID)
, PJM_PROJECT.ALL_TASK_IDTONAME(PBT.LENDING_TASK_ID)
, CG2.COST_GROUP_ID
, CG2.COST_GROUP
, SUM(PBT.OUTSTANDING_QUANTITY)
, SUM(DECODE(SIGN(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE) - 1)
, -1
, PBT.OUTSTANDING_QUANTITY
, 0))
, SUM(DECODE(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE)
, 1
, PBT.OUTSTANDING_QUANTITY
, 0))
, SUM(DECODE(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE)
, 2
, PBT.OUTSTANDING_QUANTITY
, 0))
, SUM(DECODE(SIGN(TRUNC((SYSDATE - PBT.LOAN_DATE - 1) / PJM_BORROW_PAYBACK.BUCKET_SIZE) - 2)
, 1
, PBT.OUTSTANDING_QUANTITY
, 0))
FROM PJM_BORROW_TRANSACTIONS PBT
, PJM_PROJECT_PARAMETERS PP1
, PJM_PROJECT_PARAMETERS PP2
, CST_COST_GROUPS CG1
, CST_COST_GROUPS CG2
WHERE PP1.PROJECT_ID = PBT.BORROW_PROJECT_ID
AND PP1.ORGANIZATION_ID = PBT.ORGANIZATION_ID
AND PP2.PROJECT_ID = PBT.LENDING_PROJECT_ID
AND PP2.ORGANIZATION_ID = PBT.ORGANIZATION_ID
AND CG1.COST_GROUP_ID = NVL(PP1.COSTING_GROUP_ID
, 1)
AND CG2.COST_GROUP_ID = NVL(PP2.COSTING_GROUP_ID
, 1) GROUP BY PBT.ORGANIZATION_ID
, PBT.INVENTORY_ITEM_ID
, PBT.REVISION
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, CG1.COST_GROUP_ID
, CG1.COST_GROUP
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, CG2.COST_GROUP_ID
, CG2.COST_GROUP