create or replace view amis_pm_account_v
(
problemid,
factid,
factname,
workdocid,
projid,
auditobj,
objid,
opjadd,
quescode,
quesdesc,
quesword,
basic,
biztype,
bizunit,
"cycle",
point,
bizid,
quesstart,
finddate,
finder,
cuurflag,
reminddate,
problemdesc,
defect,
badlevel,
bigcode,
chg,
recdate,
recflag,
receffect,
recdesc,
followway,
follower,
followdate,
modifier,
modifidate,
uuid,
bizdesc,
problemno,
problemnochn,
lastmod,
lastmoddate,
recmind,
recenddate,
norecreason,
problemcount,
sid_property,
recamt,
quesamt,
selfcode,
base,
mainoper,
dept,
createdate,
org_seq,
depttype,
mulct,
principal,
PRONAME
)
as
select account."PROBLEMID", ACCOUNT."FACTID", ACCOUNT."FACTNAME", ACCOUNT."WORKDOCID", ACCOUNT."PROJID", ACCOUNT."AUDITOBJ", ACCOUNT."OBJID", ACCOUNT."OPJADD", ACCOUNT."QUESCODE", ACCOUNT."QUESDESC", ACCOUNT."QUESWORD", ACCOUNT."BASIC", ACCOUNT."BIZTYPE", ACCOUNT."BIZUNIT", ACCOUNT."CYCLE", ACCOUNT."POINT", ACCOUNT."BIZID", ACCOUNT."QUESSTART", ACCOUNT."FINDDATE", ACCOUNT."FINDER", ACCOUNT."CUURFLAG", ACCOUNT."REMINDDATE", ACCOUNT."PROBLEMDESC", ACCOUNT."DEFECT", ACCOUNT."BADLEVEL", ACCOUNT."BIGCODE", ACCOUNT."CHG", ACCOUNT."RECDATE", ACCOUNT."RECFLAG", ACCOUNT."RECEFFECT", ACCOUNT."RECDESC", ACCOUNT."FOLLOWWAY", ACCOUNT."FOLLOWER", ACCOUNT."FOLLOWDATE", ACCOUNT."MODIFIER", ACCOUNT."MODIFIDATE", ACCOUNT."UUID", ACCOUNT."BIZDESC", ACCOUNT."PROBLEMNO", ACCOUNT."PROBLEMNOCHN", ACCOUNT."LASTMOD", ACCOUNT."LASTMODDATE", ACCOUNT."RECMIND", ACCOUNT."RECENDDATE", ACCOUNT."NORECREASON", ACCOUNT."PROBLEMCOUNT", ACCOUNT."STD_PROPERTY", ACCOUNT."RECAMT", ACCOUNT."QUESAMT", ACCOUNT."SELFCODE", ACCOUNT."BASE", PROJECT.MAINOPER, PROJECT.DEPT, PROJECT.CREATEDATE, SAT.ORG_SEQ, PROJECT.DEPTTYPE, PRINCIPal.MULCT, PRINCIPal.PRINCIPal, project.PRONAME FROM AMIS_PM_ACCOUNT ACCOUNT, AMIS_PM_PROJECTINFO PROJECT, AS_ORG_SAT SAT, AMIS_PM_PRINCIPAL PRINCIPAL WHERE ACCOUNT.PROJID = PROJECT.ID (+) AND ACCOUNT.PROBLEMID = PRINCIPAL.QUESID (+) AND PROJECT.PROTYPE NOT IN '0005' AND PROJECT.DEPT=SAT.ORG_ID;