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_ITEM_BORROW_PAYBACK_QTY_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.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