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.

[Home] [Help]

View: PJM_BORROW_PAYBACK_SUMMARY_V

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

View Text

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

Columns

Name
ORGANIZATION_ID
INVENTORY_ITEM_ID
REVISION
BORROW_PROJECT_ID
BORROW_PROJECT_NUMBER
BORROW_PROJECT_NAME
BORROW_TASK_ID
BORROW_TASK_NUMBER
BORROW_TASK_NAME
BORROW_COST_GROUP_ID
BORROW_COST_GROUP
LENDING_PROJECT_ID
LENDING_PROJECT_NUMBER
LENDING_PROJECT_NAME
LENDING_TASK_ID
LENDING_TASK_NUMBER
LENDING_TASK_NAME
LENDING_COST_GROUP_ID
LENDING_COST_GROUP
OUTSTANDING_QUANTITY
AGING_BUCKET1
AGING_BUCKET2
AGING_BUCKET3
AGING_BUCKET4