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.MRP_UNIT_BORROW_QTY_V

Source

View Text - Preformatted


SELECT msi.compile_designator, msi.inventory_item_id, msi.organization_id, orgs.organization_id, pbt.borrow_transaction_id, pbt.scheduled_payback_date, pbt.borrow_project_id, pbt.borrow_task_id, pbt.lending_project_id, pbt.lending_task_id, msn.end_item_unit_number, SUM(1) FROM mtl_unit_transactions mut, mtl_serial_numbers msn, pjm_borrow_transactions pbt, mrp_system_items msi, mrp_plan_organizations_v orgs WHERE msn.inventory_item_id = mut.inventory_item_id AND msn.serial_number = mut.serial_number AND mut.transaction_id = pbt.borrow_transaction_id AND pbt.outstanding_quantity > 0 AND nvl(msi.effectivity_control, 1) = 2 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.borrow_transaction_id, pbt.scheduled_payback_date, pbt.borrow_project_id, pbt.borrow_task_id, pbt.lending_project_id, pbt.lending_task_id, msn.end_item_unit_number

View Text - HTML Formatted

SELECT MSI.COMPILE_DESIGNATOR
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, ORGS.ORGANIZATION_ID
, PBT.BORROW_TRANSACTION_ID
, PBT.SCHEDULED_PAYBACK_DATE
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, MSN.END_ITEM_UNIT_NUMBER
, SUM(1)
FROM MTL_UNIT_TRANSACTIONS MUT
, MTL_SERIAL_NUMBERS MSN
, PJM_BORROW_TRANSACTIONS PBT
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE MSN.INVENTORY_ITEM_ID = MUT.INVENTORY_ITEM_ID
AND MSN.SERIAL_NUMBER = MUT.SERIAL_NUMBER
AND MUT.TRANSACTION_ID = PBT.BORROW_TRANSACTION_ID
AND PBT.OUTSTANDING_QUANTITY > 0
AND NVL(MSI.EFFECTIVITY_CONTROL
, 1) = 2
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.BORROW_TRANSACTION_ID
, PBT.SCHEDULED_PAYBACK_DATE
, PBT.BORROW_PROJECT_ID
, PBT.BORROW_TASK_ID
, PBT.LENDING_PROJECT_ID
, PBT.LENDING_TASK_ID
, MSN.END_ITEM_UNIT_NUMBER