VIEW: APPS.MRP_ONHAND_QUANTITIES_SC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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