VIEW: APPS.CSC_CONDITION_HEADERS_V

Source

View Text - Preformatted

SELECT och.id condition_header_id , och.sfwt_flag sfwt_flag, och.acn_id action_id, och.object_id object_id, och.description description, och.short_description short_description, och.comments comments, och.one_time_yn one_time_yn, och.name condition_name, och.condition_valid_yn condition_valid_yn, och.before_after before_after, och.template_yn template_yn, och.date_active date_active, och.date_inactive date_inactive, och.cnh_type condition_header_type, oa.name Action_name, oa.description Action_description, oa.acn_type action_type, oa.counter_action_yn counter_action_yn, oa.enabled_yn action_enabled from okc_condition_headers_v och, okc_actions_v oa WHERE och.acn_id = oa.id and och.jtot_object_code = 'CSC_PLAN_HEADER'

View Text - HTML Formatted

SELECT OCH.ID CONDITION_HEADER_ID
, OCH.SFWT_FLAG SFWT_FLAG
, OCH.ACN_ID ACTION_ID
, OCH.OBJECT_ID OBJECT_ID
, OCH.DESCRIPTION DESCRIPTION
, OCH.SHORT_DESCRIPTION SHORT_DESCRIPTION
, OCH.COMMENTS COMMENTS
, OCH.ONE_TIME_YN ONE_TIME_YN
, OCH.NAME CONDITION_NAME
, OCH.CONDITION_VALID_YN CONDITION_VALID_YN
, OCH.BEFORE_AFTER BEFORE_AFTER
, OCH.TEMPLATE_YN TEMPLATE_YN
, OCH.DATE_ACTIVE DATE_ACTIVE
, OCH.DATE_INACTIVE DATE_INACTIVE
, OCH.CNH_TYPE CONDITION_HEADER_TYPE
, OA.NAME ACTION_NAME
, OA.DESCRIPTION ACTION_DESCRIPTION
, OA.ACN_TYPE ACTION_TYPE
, OA.COUNTER_ACTION_YN COUNTER_ACTION_YN
, OA.ENABLED_YN ACTION_ENABLED
FROM OKC_CONDITION_HEADERS_V OCH
, OKC_ACTIONS_V OA
WHERE OCH.ACN_ID = OA.ID
AND OCH.JTOT_OBJECT_CODE = 'CSC_PLAN_HEADER'