SELECT ACC.ACCESS_ID, B.INCIDENT_ID, B.BUSINESS_PROCESS_ID, B.CONTRACT_SERVICE_ID, B.START_DATE, B.END_DATE FROM CSL_CONTR_BUSS_PROCESSES_ACC ACC , CSL_CONTR_BUSS_PROCESSES B WHERE B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID AND B.INCIDENT_ID = ACC.INCIDENT_ID AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
SELECT ACC.ACCESS_ID
, B.INCIDENT_ID
, B.BUSINESS_PROCESS_ID
, B.CONTRACT_SERVICE_ID
, B.START_DATE
, B.END_DATE
FROM CSL_CONTR_BUSS_PROCESSES_ACC ACC
, CSL_CONTR_BUSS_PROCESSES B
WHERE B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID
AND B.INCIDENT_ID = ACC.INCIDENT_ID
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
|
|
|