[Home] [Help]
View: MRP_ITEM_BORROW_PAYBACK_QTY_V
View Text
SELECT MSI.COMPILE_DESIGNATOR
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, ORGS.ORGANIZATION_ID
, PBT.SCHEDULED_PAYBACK_DATE
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, SUM(PBT.OUTSTANDING_QUANTITY)
FROM PJM_BORROW_TRANSACTIONS PBT
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE PBT.OUTSTANDING_QUANTITY > 0
AND NVL(MSI.EFFECTIVITY_CONTROL
, 1) = 1
AND MSI.INVENTORY_ITEM_ID = PBT.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = PBT.ORGANIZATION_ID
AND MSI.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR
AND MSI.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION GROUP BY MSI.COMPILE_DESIGNATOR
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, ORGS.ORGANIZATION_ID
, PBT.SCHEDULED_PAYBACK_DATE
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
Columns
Name |
COMPILE_DESIGNATOR |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
OWNING_ORGANIZATION_ID |
PAYBACK_DATE |
BORROW_PROJECT_ID |
BORROW_TASK_ID |
LENDING_PROJECT_ID |
LENDING_TASK_ID |
QUANTITY |