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

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRP_UNIT_BORROW_QTY_V

View Text

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

Columns

Name
COMPILE_DESIGNATOR
INVENTORY_ITEM_ID
ORGANIZATION_ID
OWNING_ORG_ID
BORROW_TRANSACTION_ID
PAYBACK_DATE
BORROW_PROJECT_ID
BORROW_TASK_ID
LENDING_PROJECT_ID
LENDING_TASK_ID
END_ITEM_UNIT_NUMBER
QUANTITY