SELECT ACC.ACCESS_ID , B.BUSINESS_PROCESS_ID , B.ORDER_TYPE_ID , B.NAME , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.SERVICE_REQUEST_FLAG , B.DEPOT_REPAIR_FLAG , B.FIELD_SERVICE_FLAG , B.CONTRACTS_FLAG , B.STAND_ALONE_FLAG FROM CS_BUSINESS_PROCESSES B , JTM_CS_BUSINESS_PROCESSES_ACC ACC WHERE B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID
SELECT ACC.ACCESS_ID
, B.BUSINESS_PROCESS_ID
, B.ORDER_TYPE_ID
, B.NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SERVICE_REQUEST_FLAG
, B.DEPOT_REPAIR_FLAG
, B.FIELD_SERVICE_FLAG
, B.CONTRACTS_FLAG
, B.STAND_ALONE_FLAG
FROM CS_BUSINESS_PROCESSES B
, JTM_CS_BUSINESS_PROCESSES_ACC ACC
WHERE B.BUSINESS_PROCESS_ID = ACC.BUSINESS_PROCESS_ID
|
|
|