CREATE OR REPLACE VIEW adempiere.JP_StorageOnHand_Org_RV AS
SELECT 
 s.AD_Client_ID AS AD_Client_ID
 ,0 AS AD_Org_ID
 ,s.AD_Org_ID AS JP_Org_ID
 ,info.JP_Corporation_ID AS JP_Corporation_ID
 ,s.M_Product_ID AS M_Product_ID
 ,p.C_UOM_ID AS C_UOM_ID
 ,p.Discontinued AS Discontinued
 ,p.ProductType AS ProductType
 ,p.IsStocked AS IsStocked
 ,p.IsBOM AS IsBOM
 ,p.IsDropShip AS IsDropShip
 ,p.M_Product_Category_ID AS M_Product_Category_ID
 ,pc.JP_ProductCategoryL1_ID AS JP_ProductCategoryL1_ID
 ,pl1.JP_ProductCategoryL2_ID AS JP_ProductCategoryL2_ID
 ,s.QtyOnHand AS QtyOnHand
FROM adempiere.JP_StorageOnHand_Org s
	INNER JOIN adempiere.M_Product p ON(s.M_Product_ID = p.M_Product_ID)
	INNER JOIN adempiere.M_Product_Category pc ON (p.M_Product_Category_ID=pc.M_Product_Category_ID)
		LEFT OUTER JOIN adempiere.JP_ProductCategoryL1 pl1 ON (pc.JP_ProductCategoryL1_ID=pl1.JP_ProductCategoryL1_ID)
        INNER JOIN adempiere.AD_OrgInfo info ON (s.AD_Org_ID = info.AD_Org_ID)