DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKC_XPRT_RULE_HDRS_ALL_V

Object Details
Object Name: OKC_XPRT_RULE_HDRS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_XPRT_RULE_HDRS_ALL_V
Subobject Name:
Status: VALID

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.OKC_XPRT_RULE_HDRS_ALL_V references the following:

SchemaAPPS
SynonymOKC_XPRT_RULE_HDRS_ALL
SynonymOKC_XPRT_RULE_HDRS_ALL_ACTIVE
APPS.OKC_XPRT_RULE_HDRS_ALL_V is referenced by following:

SchemaAPPS
Package BodyOKC_XPRT_RULES_ENGINE_PVT - show dependent code
Package BodyOKC_XPRT_UTIL_PVT - show dependent code