VIEW: APPS.MRP_ITEM_BORROW_PAYBACK_QTY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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