[Home] [Help] [Dependency Information]
Object Name: | OKC_RG_PARTY_ROLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_RG_PARTY_ROLES_V |
Subobject Name: | |
Status: | VALID |
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
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. |
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;
|
|
|