VIEW: APPS.HRI_CL_ORG_BGR_V

Source

View Text - Preformatted

SELECT obr.ID ID , obr.VALUE VALUE , obr.start_date start_date , obr.end_date end_date , obr.order_by order_by , obr.responsibility_id responsibility_id , obr.bg_security_flag_code bg_security_flag_code FROM hri_cl_org_bgr_n_v obr UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , ' ' order_by , -1 responsibility_id , 'Y' bg_security_flag_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT OBR.ID ID
, OBR.VALUE VALUE
, OBR.START_DATE START_DATE
, OBR.END_DATE END_DATE
, OBR.ORDER_BY ORDER_BY
, OBR.RESPONSIBILITY_ID RESPONSIBILITY_ID
, OBR.BG_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
FROM HRI_CL_ORG_BGR_N_V OBR UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, ' ' ORDER_BY
, -1 RESPONSIBILITY_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY