View: MRP_ONHAND_QUANTITIES_SC_V

Product:	MRP - Master Scheduling/MRP
Description:	On hand quantities view
Implementation/DBA Data:	APPS.MRP_ONHAND_QUANTITIES_SC_V

View Text

SELECT MFQ.QUERY_ID
, MOH.INVENTORY_ITEM_ID
, MTF.ITEM_NUMBER
, MOH.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, MPO.COMPILE_DESIGNATOR
, MOH.SUB_INVENTORY_CODE
, MOH.NETTABLE_QUANTITY
, MOH.NONNETTABLE_QUANTITY
, MOH.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(MOH.PROJECT_ID)
, MOH.TASK_ID
, MRP_GET_PROJECT.TASK(MOH.TASK_ID)
, MOH.END_ITEM_UNIT_NUMBER
FROM MRP_ONHAND_QUANTITIES MOH
, MTL_ITEM_FLEXFIELDS MTF
, MRP_SYSTEM_ITEMS MSI
, MRP_PLAN_ORGANIZATIONS_V MPO
, MRP_FORM_QUERY MFQ
WHERE MOH.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MOH.COMPILE_DESIGNATOR = MSI.COMPILE_DESIGNATOR
AND MOH.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MTF.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MTF.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MPO.PLANNED_ORGANIZATION
AND MSI.COMPILE_DESIGNATOR = MPO.COMPILE_DESIGNATOR
AND MFQ.NUMBER1 = MOH.INVENTORY_ITEM_ID
AND MFQ.NUMBER2 = MOH.ORGANIZATION_ID
AND MFQ.CHAR1 = MOH.COMPILE_DESIGNATOR

Columns