SQL QUERY FOR EXTRACTING SERVICE BUSINESS PROCESS ORACLE R12

SELECT NAME            AS NAME,
  DESCRIPTION          AS DESCRIPTION,
  START_DATE_ACTIVE    AS START_DATE,
  END_DATE_ACTIVE      AS END_DATE,
  DEPOT_REPAIR_FLAG    AS DEPOT_REPAIR,
  FIELD_SERVICE_FLAG   AS FIELD_SERVICE,
  SERVICE_REQUEST_FLAG AS SERVICE_REQUEST
FROM CS_BUSINESS_PROCESSES;
 
SELECT CBP.NAME          AS NAME,
  CTT.NAME               AS SERVICE_ACTIVITY,
  CBPT.START_DATE_ACTIVE AS START_DATE,
  CBP.END_DATE_ACTIVE    AS END_DATE
FROM CS_BUS_PROCESS_TXNS CBPT,
  CS_TRANSACTION_TYPES CTT,
  CS_BUSINESS_PROCESSES CBP
WHERE CBP.BUSINESS_PROCESS_ID = CBPT.BUSINESS_PROCESS_ID
AND CBPT.TRANSACTION_TYPE_ID  = CTT.TRANSACTION_TYPE_ID