VIEW: APPS.OKC_XPRT_RULE_HDRS_ALL_V

Source

View Text - Preformatted

SELECT RULE_ID, ORG_ID, INTENT, STATUS_CODE, RULE_NAME, RULE_DESCRIPTION, ORG_WIDE_FLAG, PUBLISHED_FLAG, CONDITION_EXPR_CODE, REQUEST_ID, RULE_TYPE, LINE_LEVEL_FLAG,OBJECT_VERSION_NUMBER, ACTIVATION_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_ID,PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE FROM okc_xprt_rule_hdrs_all WHERE status_code = 'ACTIVE' UNION ALL SELECT RULE_ID, ORG_ID, INTENT, STATUS_CODE, RULE_NAME, RULE_DESCRIPTION, ORG_WIDE_FLAG, PUBLISHED_FLAG, CONDITION_EXPR_CODE, REQUEST_ID, RULE_TYPE,LINE_LEVEL_FLAG, OBJECT_VERSION_NUMBER, ACTIVATION_DATE, CREATED_BY, CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_ID,PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE FROM okc_xprt_rule_hdrs_all_active

View Text - HTML Formatted

SELECT RULE_ID
, ORG_ID
, INTENT
, STATUS_CODE
, RULE_NAME
, RULE_DESCRIPTION
, ORG_WIDE_FLAG
, PUBLISHED_FLAG
, CONDITION_EXPR_CODE
, REQUEST_ID
, RULE_TYPE
, LINE_LEVEL_FLAG
, OBJECT_VERSION_NUMBER
, ACTIVATION_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM OKC_XPRT_RULE_HDRS_ALL
WHERE STATUS_CODE = 'ACTIVE' UNION ALL SELECT RULE_ID
, ORG_ID
, INTENT
, STATUS_CODE
, RULE_NAME
, RULE_DESCRIPTION
, ORG_WIDE_FLAG
, PUBLISHED_FLAG
, CONDITION_EXPR_CODE
, REQUEST_ID
, RULE_TYPE
, LINE_LEVEL_FLAG
, OBJECT_VERSION_NUMBER
, ACTIVATION_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM OKC_XPRT_RULE_HDRS_ALL_ACTIVE