CREATE VIEW "SBODEMODE"."SBO_PROFIT_CTR_TXT" ( "PROFIT_CTR", "TXTSH", "TXTMD" ) AS SELECT TO_CHAR(P."PrcCode") AS "PROFIT_CTR", 
				left(P."PrcName",20) AS "TXTSH", 
				left(P."PrcName",40) AS "TXTMD"
				FROM OPRC AS P