VIEW: APPS.HRI_CL_ORG_HRCY_BX_V

Source

View Text - Preformatted

SELECT ost.id ID , ost.value VALUE , ost.start_date START_DATE , ost.end_date END_DATE , ost.responsibility_id RESPONSIBILITY_ID , ost.primary_structure_flag_code primary_structure_flag , ost.business_group_id business_group_id FROM HRI_CL_ORG_HRCY_N_V ost WHERE ost.bg_security_flag_code = 'Y' AND ost.hri_security_flag_code = 'Y' WITH READ ONLY

View Text - HTML Formatted

SELECT OST.ID ID
, OST.VALUE VALUE
, OST.START_DATE START_DATE
, OST.END_DATE END_DATE
, OST.RESPONSIBILITY_ID RESPONSIBILITY_ID
, OST.PRIMARY_STRUCTURE_FLAG_CODE PRIMARY_STRUCTURE_FLAG
, OST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HRI_CL_ORG_HRCY_N_V OST
WHERE OST.BG_SECURITY_FLAG_CODE = 'Y'
AND OST.HRI_SECURITY_FLAG_CODE = 'Y' WITH READ ONLY