CREATE OR REPLACE VIEW TRPS_MCHNT_FRNT 
  AS
   SELECT PM.SHCODE,PM.LOCNO,PM.B1CODE,B3FULL,MNAME M3FULL,POCODE 
   PO,PM.SCODE,PM.ACTIVE,PM.SHIP_FLAG,PM.POSTRING,PM.MANAGER,PM.UCODE,PM.STYLENO,STYLEBUY,DESCRIPTION,
   FAB1NAME FABRIC,VNAME,SUM(QTY) QTY
 FROM 
   PO_MCHNT_BYR PM,FABRIC F,DELIVERY D,VENDOR V,FAB1 F1
 WHERE PM.STYLENO=F.STYLENO(+) 
       AND PM.STYLENO=D.STYLENO(+) 
       AND D.VCODE=V.VCODE(+) 
       AND F.FAB1NO=F1.FAB1NO(+) 
       AND F.MAINALLIED(+)='M' 
       AND NVL(D.FLAG(+),'S')<>'C' 
       AND PM.POSTRING<>'Z'
 GROUP BY 
      PM.SHCODE,PM.LOCNO,PM.B1CODE,B3FULL,MNAME,POCODE,PM.SCODE,PM.ACTIVE,PM.SHIP_FLAG,PM.POSTRING,PM.MANAGER,PM.UCODE,PM.STYLENO,STYLEBUY,
      DESCRIPTION,FAB1NAME,VNAME;

CREATE OR REPLACE VIEW PO_MCHNT_BYR 
	AS
	SELECT P.SHCODE,P.LOCNO,POCODE,P.ACTIVE,SHIP_FLAG,P.POSTRING,P.B1CODE,S.SCODE,STYLENO,STYLEBUY,S.DESCRIPTION,
	U1.UCODE MANAGER,U2.UCODE,U0.LNAME||'/'||U1.LNAME||'/'||U2.LNAME MNAME,B3.B3FULL
FROM 
	USERMST U0,USERMST U1,USERMST U2,POMST P,STYLE S,BUYER1 B1,BUYER2 B2,BUYER3 B3
WHERE 
	U0.UCODE=U1.MANAGER 
	AND U1.UCODE=P.MANAGER 
	AND U1.UCODE=U2.MANAGER 
	AND U2.UCODE=P.UCODE 
	AND P.POCODE=S.PO 
	AND S.B1CODE=B1.B1CODE 
	AND S.B2CODE=B2.B2CODE 
	AND S.B3CODE=B3.B3CODE 
	AND B3.B2CODE=B2.B2CODE 
	AND B3.B1CODE=B1.B1CODE 
	AND B2.B1CODE=B1.B1CODE 
	AND P.ACTIVE<>'C' 
ORDER 
	BY 1;

 SQL> SELECT * FROM TRPS_MCHNT_FRNT;