[Home] [Help] [Dependency Information]
Object Name: | OKC_RULES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_RULES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The values of the required "attributes" of a RULE GROUP
Bonus, Incentive (+)
Penalty, Damage (-)
DEFINITION
COVER describes the conditions (in terms of who, where, when etc.) under which an an obligation exists
In the when dimension it can be the duration, the period the actual date/time etc.
In the where dimension it can be the country, region, site facility etc.
In the who it can be person, role, organisation structure element etc.
There are probably other dimensions of cover as yet uncovered (chortle !) such as platform, system etc.
EXAMPLE
MISCELLANEOUS
DEFINITION
A GUIDELINE is a standard, process or procedure which instructs the specific performance required.
EXAMPLE
Military Standards
Material Handling Data Sheet
MISCELLANEOUS
Are inspections required?
Customer Source Inspection (at site)
Government Source Inspection (")
First Article Inspection
Payment to be withheld or retained
Payment as deposit or advance
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Primary key column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | CHAR | (1) | Dummy column as okc_rules_tl table is removed | |
OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
OBJECT2_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
OBJECT3_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
OBJECT1_ID2 | VARCHAR2 | (200) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. | |
OBJECT2_ID2 | VARCHAR2 | (200) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. | |
OBJECT3_ID2 | VARCHAR2 | (200) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. | |
JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. | |
JTOT_OBJECT2_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. | |
JTOT_OBJECT3_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. | |
DNZ_CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
RGP_ID | NUMBER | Foreign key to OKC_RULE_GROUPS_B. | ||
PRIORITY | NUMBER | (5) | Order of evaluation. | |
STD_TEMPLATE_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns. |
COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
WARN_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
TEXT | VARCHAR2 | (0) | Dummy column as okc_rules_tl table is removed | |
RULE_INFORMATION_CATEGORY | VARCHAR2 | (90) | Yes | Used to define flexfield context while defining rule flexfields. |
RULE_INFORMATION1 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION2 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION3 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION4 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION5 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION6 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION7 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION8 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION9 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION10 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
RULE_INFORMATION12 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION13 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION14 | VARCHAR2 | (450) | Stores rule flexfield information. | |
RULE_INFORMATION15 | VARCHAR2 | (450) | Stores rule flexfield information. | |
TEMPLATE_YN | VARCHAR2 | (3) | Indicates whether the rule is a Template or Not. | |
ANS_SET_JTOT_OBJECT_CODE | VARCHAR2 | (30) | The JTF Object to derive the answer for Condition rules. | |
ANS_SET_JTOT_OBJECT_ID1 | VARCHAR2 | (40) | The ID for the JTF Object to derive the answer for Condition rules. | |
ANS_SET_JTOT_OBJECT_ID2 | VARCHAR2 | (40) | The Composite ID for the JTF Object to derive the answer for Condition rules. | |
DISPLAY_SEQUENCE | NUMBER | The sequence or order in which the rules will be displayed within a rule group. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, OBJECT1_ID1
, OBJECT2_ID1
, OBJECT3_ID1
, OBJECT1_ID2
, OBJECT2_ID2
, OBJECT3_ID2
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, JTOT_OBJECT3_CODE
, DNZ_CHR_ID
, RGP_ID
, PRIORITY
, STD_TEMPLATE_YN
, COMMENTS
, WARN_YN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TEXT
, RULE_INFORMATION_CATEGORY
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, RULE_INFORMATION4
, RULE_INFORMATION5
, RULE_INFORMATION6
, RULE_INFORMATION7
, RULE_INFORMATION8
, RULE_INFORMATION9
, RULE_INFORMATION10
, RULE_INFORMATION11
, RULE_INFORMATION12
, RULE_INFORMATION13
, RULE_INFORMATION14
, RULE_INFORMATION15
, TEMPLATE_YN
, ANS_SET_JTOT_OBJECT_CODE
, ANS_SET_JTOT_OBJECT_ID1
, ANS_SET_JTOT_OBJECT_ID2
, DISPLAY_SEQUENCE
FROM APPS.OKC_RULES_V;
|
|
|