Product: | AMW - Internal Controls Manager (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CTX
, PPID
, PPN
, PDN
, PCDE
, PID
, PON
, POD
, RNM
, RID
, RR
, RDS
, RT1
, RT2
, RT3
, RT4
, RT5
, RT6
, RT7
, RT8
, RT9
, RT10
, RLKL
, RIMP
, RMAT
, RMVA
, RAPP
, RCLASS
, CNM
, RC
, CDS
, APN
, ADE
, AOE
, CAPP
, CLOC
, CTYP
, CAUT
, CAPL
, CSRC
, CPEV
, CBGR
, CJOB
, CPRV
, CDET
, CDIS
, CKEY
, CVSO
, CVNM
, CVIN
, CCLASS
, CCM1
, CCM2
, CCM3
, CCM4
, CCM5
, CCM6
, CCM7
, CCM8
, CCM9
, CCM10
, CCT1
, CCT2
, CCT3
, CCT4
, CCT5
, CCT6
, CCT7
, CCT8
, CCT9
, CCT10
, CAS1
, CAS2
, CAS3
, CAS4
, CAS5
, CAS6
, CAS7
, CAS8
, CAS9
, CAS10
, -100 PARTY_ID
FROM AMW_BASIC_RCM_V UNION ALL SELECT CTX
, PPID
, PPN
, PDN
, PCDE
, PID
, PON
, POD
, RNM
, RID
, RR
, RDS
, RT1
, RT2
, RT3
, RT4
, RT5
, RT6
, RT7
, RT8
, RT9
, RT10
, RLKL
, RIMP
, RMAT
, RMVA
, RAPP
, RCLASS
, CNM
, RC
, CDS
, APN
, ADE
, AOE
, CAPP
, CLOC
, CTYP
, CAUT
, CAPL
, CSRC
, CPEV
, CBGR
, CJOB
, CPRV
, CDET
, CDIS
, CKEY
, CVSO
, CVNM
, CVIN
, CCLASS
, CCM1
, CCM2
, CCM3
, CCM4
, CCM5
, CCM6
, CCM7
, CCM8
, CCM9
, CCM10
, CCT1
, CCT2
, CCT3
, CCT4
, CCT5
, CCT6
, CCT7
, CCT8
, CCT9
, CCT10
, CAS1
, CAS2
, CAS3
, CAS4
, CAS5
, CAS6
, CAS7
, CAS8
, CAS9
, CAS10
, AORV.PARTY_ID AS PARTY_ID
FROM AMW_BASIC_RCM_V
, AMW_OWNER_ROLES_V AORV
WHERE AORV.ROLE_NAME='AMW_RL_PROC_OWNER_ROLE'
AND PID=AORV.PK1_VALUE