VIEW: APPS.OKC_XPRT_RULE_COND_VALS_ACT_V

Source

View Text - Preformatted

SELECT RULE_CONDITION_VALUE_ID, RULE_CONDITION_ID, OBJECT_VALUE_CODE, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM okc_xprt_rule_cond_vals WHERE RULE_CONDITION_ID IN (SELECT RULE_CONDITION_ID FROM OKC_XPRT_RULE_CONDITIONS WHERE RULE_ID IN (SELECT RULE_ID FROM OKC_XPRT_RULE_HDRS_ALL WHERE STATUS_CODE = 'ACTIVE')) UNION ALL SELECT RULE_CONDITION_VALUE_ID, RULE_CONDITION_ID, OBJECT_VALUE_CODE, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM OKC_XPRT_RULE_COND_VALS_ACTIVE

View Text - HTML Formatted

SELECT RULE_CONDITION_VALUE_ID
, RULE_CONDITION_ID
, OBJECT_VALUE_CODE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKC_XPRT_RULE_COND_VALS
WHERE RULE_CONDITION_ID IN (SELECT RULE_CONDITION_ID
FROM OKC_XPRT_RULE_CONDITIONS
WHERE RULE_ID IN (SELECT RULE_ID
FROM OKC_XPRT_RULE_HDRS_ALL
WHERE STATUS_CODE = 'ACTIVE')) UNION ALL SELECT RULE_CONDITION_VALUE_ID
, RULE_CONDITION_ID
, OBJECT_VALUE_CODE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKC_XPRT_RULE_COND_VALS_ACTIVE