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

VIEW: APPS.OKC_RG_PARTY_ROLES_V

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

View Type

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


DEFINITION
Intersection entity (relationship) which is used to associate an actual contract party or role
to the defined rule group mode (via another intersection RULE ROLE)
It defaults to the party having that role (or the role itself if no party) but may be overridden
EXAMPLE
a Billing function may have a Biller and a Billee
for a sales contract the biller could be vendor and the billee customer
(this could however be overridden if the customer requires to bill the vendor for non performance, say)
whereas in a lease contract the biller could be leasor and the billee leasee
MISCELLANEOUS


[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.
RGP_ID NUMBER
Yes Foreign key to OKC_RULE_GROUPS_B.
RRD_ID NUMBER
Yes Foreign key to OKC_RG_ROLE_DEFS.
CPL_ID NUMBER

Foreign key to OKC_K_PARTY_ROLES_B.
DNZ_CHR_ID NUMBER
Yes Contract ID. Denormalized for performance.
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.
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
,      RGP_ID
,      RRD_ID
,      CPL_ID
,      DNZ_CHR_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_RG_PARTY_ROLES_V;

Dependencies

[top of page]

APPS.OKC_RG_PARTY_ROLES_V references the following:

SchemaAPPS
SynonymOKC_RG_PARTY_ROLES
APPS.OKC_RG_PARTY_ROLES_V is referenced by following:

SchemaAPPS
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
ViewOKC_RG_PARTIES_BLK_V
PL/SQL PackageOKC_RMP_PVT - show dependent code
Package BodyOKC_RULE_PUB - show dependent code
Package BodyOKC_RULE_PVT - show dependent code
Package BodyOKL_CONTRACT_PVT - show dependent code
Package BodyOKL_CONTRACT_REBOOK_PVT - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PUB - show dependent code
PL/SQL PackageOKL_OKC_MIGRATION_PVT - show dependent code