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


VIEW: APPS.OKC_RULES_V

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

View Type

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


[View Source]

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

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;

Dependencies

[top of page]

APPS.OKC_RULES_V references the following:

SchemaAPPS
SynonymOKC_RULES_B
APPS.OKC_RULES_V is referenced by following:

SchemaAPPS
ViewOKCAUDET_RULE_GROUPS_V
Package BodyOKC_CONTRACT_PVT - show dependent code
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
Package BodyOKC_EXTEND_PVT - show dependent code
ViewOKC_K_SALES_AGRMNTS_V
Package BodyOKC_QA_DATA_INTEGRITY - show dependent code
Package BodyOKC_RENEW_PUB - show dependent code
Package BodyOKC_RENEW_PVT - show dependent code
ViewOKC_RULES1_BLK_V
Package BodyOKC_RULE_PUB - show dependent code
Package BodyOKC_RULE_PVT - show dependent code
Package BodyOKC_RUL_PVT - show dependent code
PL/SQL PackageOKC_RUL_PVT - show dependent code
Package BodyOKC_TIME_RES_PVT - show dependent code
Package BodyOKL_AM_CALCULATE_QUOTE_PVT - show dependent code
Package BodyOKL_AM_VENDOR_RES_SHARE_PVT - show dependent code
Package BodyOKL_AUTO_INSURANCE_PVT - show dependent code
Package BodyOKL_BILLING_CONTROLLER_PVT - show dependent code
Package BodyOKL_BILL_UPFRONT_TAX_PVT - show dependent code
Package BodyOKL_CONS_BILL - show dependent code
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_INFO - show dependent code
Package BodyOKL_CONTRACT_REBOOK_PVT - show dependent code
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
Package BodyOKL_CPY_PDT_RULS_PVT - show dependent code
Package BodyOKL_CREATE_KLE_PVT - show dependent code
PL/SQL PackageOKL_CREDIT_CHECKLIST_PVT - show dependent code
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
ViewOKL_CURE_VENDOR_SUMRY_UV
PL/SQL PackageOKL_DEAL_CREATE_PUB - show dependent code
Package BodyOKL_DEAL_CREATE_PUB - show dependent code
PL/SQL PackageOKL_DEAL_CREAT_PVT - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code
PL/SQL PackageOKL_FUNDING_CHECKLIST_PVT - show dependent code
Package BodyOKL_FUNDING_PVT - show dependent code
Package BodyOKL_INTERNAL_BILLING_PVT - show dependent code
Package BodyOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PUB - show dependent code
PL/SQL PackageOKL_LA_PAYMENTS_PVT - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
ViewOKL_LA_PAYMENTS_UV
Package BodyOKL_LA_PROPERTY_TAX_PVT - show dependent code
Package BodyOKL_LA_SALES_TAX_PVT - show dependent code
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
Package BodyOKL_MAINTAIN_FEE_PVT - show dependent code
Package BodyOKL_MASS_REBOOK_PVT - show dependent code
PL/SQL PackageOKL_MASTER_LEASE_AGREEMENT_PUB - show dependent code
PL/SQL PackageOKL_MLA_CREATE_UPDATE_PUB - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_PAYMENT_APPLICATION_PUB - show dependent code
PL/SQL PackageOKL_PAYMENT_APPLICATION_PUB - show dependent code
Package BodyOKL_PAYMENT_APPLICATION_PVT - show dependent code
PL/SQL PackageOKL_PAYMENT_APPLICATION_PVT - show dependent code
Package BodyOKL_PROCESS_PPD_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_RGRP_RULES_PROCESS_PVT - show dependent code
PL/SQL PackageOKL_RGRP_RULES_PROCESS_PVT - show dependent code
ViewOKL_RULES_V
Package BodyOKL_RULE_APIS_PVT - show dependent code
PL/SQL PackageOKL_RULE_PUB - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code
ViewOKL_SO_PAYMENT_SCEN_UV
Package BodyOKL_SPLIT_CONTRACT_PVT - show dependent code
Package BodyOKL_SSC_WF - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_UBB_INTEGRATION_PVT - show dependent code
PL/SQL PackageOKL_VENDOR_AGREEMENT_PUB - show dependent code
Package BodyOKS_BILL_UTIL_PUB - show dependent code
Package BodyOKS_COVERAGE_MIGRATION - show dependent code
Package BodyOKS_EXTWARPRGM_OSO_PVT - show dependent code
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
ViewOKS_RULES_V