Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_XPRT_RULE_HDRS_ALL_V |
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