Product: | CSC - Customer Care |
---|---|
Description: | Defines a Condition to be evaluated upon the occurrence of an Action. |
Implementation/DBA Data: | APPS.CSC_CONDITION_HEADERS_V |
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'