VIEW: APPS.CSM_CONTR_BUSS_PROCESSES_V

Source

View Text - Preformatted

SELECT acc.access_id , acc.contract_service_id , acc.business_process_id , bpr.name , acc.start_date , acc.end_date FROM csm_contr_buss_processes_acc acc, cs_business_processes bpr WHERE acc.user_id = asg_base.get_user_id AND acc.business_process_id = bpr.business_process_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.CONTRACT_SERVICE_ID
, ACC.BUSINESS_PROCESS_ID
, BPR.NAME
, ACC.START_DATE
, ACC.END_DATE
FROM CSM_CONTR_BUSS_PROCESSES_ACC ACC
, CS_BUSINESS_PROCESSES BPR
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.BUSINESS_PROCESS_ID = BPR.BUSINESS_PROCESS_ID