[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;
APPS
OKC_RULES_B
APPS
OKCAUDET_RULE_GROUPS_V
OKC_CONTRACT_PVT
- show dependent code
OKC_COPY_CONTRACT_PVT
- show dependent code
OKC_DELETE_CONTRACT_PVT
- show dependent code
OKC_EXTEND_PVT
- show dependent code
OKC_K_SALES_AGRMNTS_V
OKC_QA_DATA_INTEGRITY
- show dependent code
OKC_RENEW_PUB
- show dependent code
OKC_RENEW_PVT
- show dependent code
OKC_RULES1_BLK_V
OKC_RULE_PUB
- show dependent code
OKC_RULE_PVT
- show dependent code
OKC_RUL_PVT
- show dependent code
OKC_RUL_PVT
- show dependent code
OKC_TIME_RES_PVT
- show dependent code
OKL_AM_CALCULATE_QUOTE_PVT
- show dependent code
OKL_AM_VENDOR_RES_SHARE_PVT
- show dependent code
OKL_AUTO_INSURANCE_PVT
- show dependent code
OKL_BILLING_CONTROLLER_PVT
- show dependent code
OKL_BILL_UPFRONT_TAX_PVT
- show dependent code
OKL_CONS_BILL
- show dependent code
OKL_CONTRACT_BOOK_PVT
- show dependent code
OKL_CONTRACT_INFO
- show dependent code
OKL_CONTRACT_REBOOK_PVT
- show dependent code
OKL_COPY_CONTRACT_PVT
- show dependent code
OKL_CPY_PDT_RULS_PVT
- show dependent code
OKL_CREATE_KLE_PVT
- show dependent code
OKL_CREDIT_CHECKLIST_PVT
- show dependent code
OKL_CS_LC_CONTRACT_PVT
- show dependent code
OKL_CS_PRINCIPAL_PAYDOWN_PVT
- show dependent code
OKL_CURE_VENDOR_SUMRY_UV
OKL_DEAL_CREATE_PUB
- show dependent code
OKL_DEAL_CREATE_PUB
- show dependent code
OKL_DEAL_CREAT_PVT
- show dependent code
OKL_DEAL_CREAT_PVT
- show dependent code
OKL_FUNDING_CHECKLIST_PVT
- show dependent code
OKL_FUNDING_PVT
- show dependent code
OKL_INTERNAL_BILLING_PVT
- show dependent code
OKL_INTERNAL_TO_EXTERNAL
- show dependent code
OKL_JTOT_CONTACT_EXTRACT_PUB
- show dependent code
OKL_LA_PAYMENTS_PVT
- show dependent code
OKL_LA_PAYMENTS_PVT
- show dependent code
OKL_LA_PAYMENTS_UV
OKL_LA_PROPERTY_TAX_PVT
- show dependent code
OKL_LA_SALES_TAX_PVT
- show dependent code
OKL_LA_VALIDATION_UTIL_PVT
- show dependent code
OKL_MAINTAIN_FEE_PVT
- show dependent code
OKL_MASS_REBOOK_PVT
- show dependent code
OKL_MASTER_LEASE_AGREEMENT_PUB
- show dependent code
OKL_MLA_CREATE_UPDATE_PUB
- show dependent code
OKL_OPEN_INTERFACE_PVT
- show dependent code
OKL_PAYMENT_APPLICATION_PUB
- show dependent code
OKL_PAYMENT_APPLICATION_PUB
- show dependent code
OKL_PAYMENT_APPLICATION_PVT
- show dependent code
OKL_PAYMENT_APPLICATION_PVT
- show dependent code
OKL_PROCESS_PPD_PVT
- show dependent code
OKL_QA_DATA_INTEGRITY
- show dependent code
OKL_RGRP_RULES_PROCESS_PVT
- show dependent code
OKL_RGRP_RULES_PROCESS_PVT
- show dependent code
OKL_RULES_V
OKL_RULE_APIS_PVT
- show dependent code
OKL_RULE_PUB
- show dependent code
OKL_SEEDED_FUNCTIONS_PVT
- show dependent code
OKL_SERVICE_INTEGRATION_PVT
- show dependent code
OKL_SO_PAYMENT_SCEN_UV
OKL_SPLIT_CONTRACT_PVT
- show dependent code
OKL_SSC_WF
- show dependent code
OKL_STREAM_BILLING_PVT
- show dependent code
OKL_UBB_INTEGRATION_PVT
- show dependent code
OKL_VENDOR_AGREEMENT_PUB
- show dependent code
OKS_BILL_UTIL_PUB
- show dependent code
OKS_COVERAGE_MIGRATION
- show dependent code
OKS_EXTWARPRGM_OSO_PVT
- show dependent code
OKS_EXTWAR_UTIL_PVT
- show dependent code
OKS_RULES_V
|
|
|
|