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


VIEW: APPS.OKC_RULE_GROUPS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


A group of RULE to be used by a contract as allowed by predefined RULE GROUP DEF


[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.
RGP_TYPE VARCHAR2 (10) Yes RGP type.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
RGD_CODE VARCHAR2 (30) Yes Foreign key to FND_LOOKUP_VALUES.
CLE_ID NUMBER

Foreign key to OKC_K_LINES_B.
CHR_ID NUMBER

Foreign key to OKC_K_HEADERS_B.
DNZ_CHR_ID NUMBER

Contract ID. Denormalized for performance.
PARENT_RGP_ID NUMBER

Surrogate key used for primary unique identifiers.
SAT_CODE VARCHAR2 (30)
Foreign key to FND_LOOKUP_VALUES.
COMMENTS VARCHAR2 (1995)
User entered comment.
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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      RGP_TYPE
,      SFWT_FLAG
,      RGD_CODE
,      CLE_ID
,      CHR_ID
,      DNZ_CHR_ID
,      PARENT_RGP_ID
,      SAT_CODE
,      COMMENTS
,      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
FROM APPS.OKC_RULE_GROUPS_V;

Dependencies

[top of page]

APPS.OKC_RULE_GROUPS_V references the following:

SchemaAPPS
SynonymOKC_RULE_GROUPS_B
SynonymOKC_RULE_GROUPS_TL
APPS.OKC_RULE_GROUPS_V is referenced by following:

SchemaAPPS
ViewOKCAUDET_RULE_GROUPS_V
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
ViewOKC_K_SALES_AGRMNTS_V
PL/SQL PackageOKC_RGP_PVT - show dependent code
Package BodyOKC_RGP_PVT - show dependent code
ViewOKC_RG_BLK_V
Package BodyOKC_RULE_PUB - show dependent code
Package BodyOKL_AM_INVOICES_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_PVT - show dependent code
Package BodyOKL_CONTRACT_REBOOK_PVT - show dependent code
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
ViewOKL_CURE_VENDOR_PROGRAM_UV
Package BodyOKL_DEAL_CREATE_PUB - show dependent code
PL/SQL PackageOKL_DEAL_CREATE_PUB - show dependent code
Package BodyOKL_DEAL_CREAT_PVT - show dependent code
PL/SQL PackageOKL_DEAL_CREAT_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_INVESTOR_INVOICE_DISB_PVT - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PUB - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
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
PL/SQL PackageOKL_OKC_MIGRATION_A_PVT - show dependent code
PL/SQL PackageOKL_OKC_MIGRATION_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
PL/SQL PackageOKL_PAYMENT_APPLICATION_PUB - show dependent code
Package BodyOKL_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_QUOTE_TO_CONTRACT_PVT - show dependent code
Package BodyOKL_RGRP_RULES_PROCESS_PVT - show dependent code
PL/SQL PackageOKL_RGRP_RULES_PROCESS_PVT - show dependent code
Package BodyOKL_RULE_APIS_PVT - show dependent code
Package BodyOKL_SECURITIZATION_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code
Package BodyOKL_SSC_WF - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_SUBSIDY_PROCESS_PVT - show dependent code
Package BodyOKL_UBB_INTEGRATION_PVT - show dependent code
PL/SQL PackageOKL_VENDOR_AGREEMENT_PUB - show dependent code
Package BodyOKL_VP_SYNC_CR_PVT - show dependent code
Package BodyOKS_BILL_UTIL_PUB - show dependent code
Package BodyOKS_COVERAGES_PVT - 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