[Home] [Help] [Dependency Information]
Object Name: | OKC_XPRT_RULE_OUTCOMES_ACT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_XPRT_RULE_OUTCOMES_ACT_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OUTCOME_ID | NUMBER | Sequence generated ID. | ||
RULE_ID | NUMBER | Rule Id. FK to OKC_XPRT_RULE_HDRS_ALL. | ||
OBJECT_TYPE | VARCHAR2 | (30) | Indicates if the Results is either a Question or a Clause. FK to FND lookup OKC_XPRT_OUTCOME_TYPE. | |
OBJECT_VALUE_ID | NUMBER | Outcome identifier. This is either Question Id or Clause Id based on the object type | ||
OBJECT_VERSION_NUMBER | NUMBER | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | ||
CREATED_BY | NUMBER | (15) | Keeps track of which user created each row. | |
CREATION_DATE | DATE | Stores the date on which each row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Keeps track of which user last updated each row. | |
LAST_UPDATE_DATE | DATE | Stores the date on which each row was last updated. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Provides access to information about the operating system login of the user who last updated each row. | |
MANDATORY_YN | VARCHAR2 | (30) | Mandatory Clause on Template. | |
MANDATORY_RWA | VARCHAR2 | (30) | Required When Applicable |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_OUTCOME_ID
, RULE_ID
, OBJECT_TYPE
, OBJECT_VALUE_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MANDATORY_YN
, MANDATORY_RWA
FROM APPS.OKC_XPRT_RULE_OUTCOMES_ACT_V;
|
|
|