[Home] [Help] [Dependency Information]
Object Name: | OKC_XPRT_RULE_HDRS_ALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_XPRT_RULE_HDRS_ALL_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Sequence generated ID. | ||
ORG_ID | NUMBER | The organization ID indicating the operating unit in which the rule is creating. FK to HR_ORGANIZATIONS_ALL. | ||
INTENT | VARCHAR2 | (1) | Rule intent. B: Buy or S: Sell | |
STATUS_CODE | VARCHAR2 | (30) | Indicates the status of the Rule and is applicable only to Organization Rules. FK to FND lookup OKC_XPRT_RULE_STATUSES. | |
RULE_NAME | VARCHAR2 | (240) | Rule name. | |
RULE_DESCRIPTION | VARCHAR2 | (2000) | Rule description. | |
ORG_WIDE_FLAG | VARCHAR2 | (1) | Flag to indicate if the template is applicable to all templates in the current operating unit | |
PUBLISHED_FLAG | VARCHAR2 | (1) | Flag to indicate if the rule was published to Configurator once | |
CONDITION_EXPR_CODE | VARCHAR2 | (30) | Indicates whether the conditions on the rule are 'Any True' or 'All True'. Possible values are 'ALL' or 'ANY'. FK to FND lookup OKC_XPRT_CONDITION_EXPRESSION. | |
REQUEST_ID | NUMBER | (15) | Keeps track of the concurrent request during which this row was created or updated. | |
RULE_TYPE | VARCHAR2 | (30) | Identify the Rule Type Values: POLICY_DEVIATION and CLAUSE_SELECTION. FK to FND_LOOKUP 'OKC_XPRT_RULE_TYPE. | |
LINE_LEVEL_FLAG | VARCHAR2 | (1) | Identify if the rule has any line level system variables. This column would be updated when the rules are activated. | |
OBJECT_VERSION_NUMBER | NUMBER | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | ||
ACTIVATION_DATE | DATE | Indicates when the rule was activated | ||
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 who 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. | |
PROGRAM_ID | NUMBER | (15) | With PROGRAM_ID, keeps track of which concurrent program created or updated each row. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row. | |
PROGRAM_UPDATE_DATE | DATE | Stores the date on which the concurrent program created or updated the row. |
Cut, paste (and edit) the following text to query this object:
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 APPS.OKC_XPRT_RULE_HDRS_ALL_V;
|
|
|