1. Problem
Analysis
[GOR2_REL].[RISKASSESSMENT].[RA_RISKASSESSMENT_ID]
[GOR2_REL].[SOXPROCESS].[PR_PROCESS_ID]
[GOR2_REL].[RISKCAT].[ZR_RISKCAT_ID]
SELECT RISKASSESSMENT_ID,
REPORTING_PERIOD_ID,
PROCESS_ID,
HIER_INSTANCE_ID,
IS_PRIMARY,
DISTANCE
FROM RT__RISKASSESSMENT_PROCESS ;
SELECT RESRELATIONSHIPID,
SETID,
PARENTID,
CHILDID,
ACTORID,
CREATIONDATE,
PARENTCONTENTTYPE,
CHILDCONTENTTYPE,
IS_NOT_PRIMARY,
IS_PRIMALITY_AUTO_ASSIGNED
FROM RESRELATIONSHIPS
where PARENTCONTENTTYPE=92 and CHILDCONTENTTYPE =77;
92 = RiskAssessment
77=SOXProcess
Once lost, and then reload
No comments:
Post a Comment