Results for “cpl_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The ORACLE EBS view APPS.OKC_CHANGE_PARTY_ROLE_V belongs to the OKC – Contracts Core product family and functions as a reporting and integration layer over the base table OKC_CHANGE_PARTY_ROLE. In Oracle EBS 12.1.1 and 12.2.2, the view is defined in the APPS schema and carries a VALID status in the ETRM repository. Its purpose is to expose party-role rows associated with contract change requests, including the acceptance date recorded against each party role. Users searching for the term acceptance_date will find this view particularly relevant because ACCEPTANCE_DATE is one of its exposed columns and mirrors the identically named column on the underlying base table.
The view is typically consumed by reporting tools, concurrent programs, and integration interfaces that need to read change party role data without directly querying the base table. Because the view is a simple projection over a single synonym, it introduces no aggregation and behaves predictably for query tuning and row-level filtering.
Underlying Base Objects
The documented base object referenced by the view is OKC_CHANGE_PARTY_ROLE, accessed through a synonym. The view text aliases this source as CPRB and selects columns directly from it. No joins, unions, or derived expressions appear in the documented definition; the view is a straight column projection. This means every row returned by OKC_CHANGE_PARTY_ROLE_V corresponds one-to-one with a row in OKC_CHANGE_PARTY_ROLE.
- Source object: OKC_CHANGE_PARTY_ROLE (synonym)
- Owner: APPS
- Object type: VIEW
- Status: VALID
Key Columns
The view exposes the following columns, each mapped directly from the base table:
- ROW_ID – the ROWID of the underlying OKC_CHANGE_PARTY_ROLE row, useful for direct row addressing.
- CRT_ID – identifier linking the party role to a contract change request.
- CPL_ID – identifier for the contract party line associated with the role.
- OBJECT_VERSION_NUMBER – optimistic locking column used by the framework to detect concurrent updates.
- ACCEPTANCE_DATE – the date on which the party role was accepted; central to queries searching for acceptance timing.
- CREATED_BY, CREATION_DATE – audit columns recording row creation.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – audit columns recording the most recent modification and session.
Common Use Cases and Queries
Typical scenarios include reporting on acceptance of party roles for a change request, identifying roles accepted within a date range, and feeding integration processes that synchronize contract change data. The following examples illustrate practical usage.
- List all party roles for a change request with their acceptance dates:
SELECT crt_id, cpl_id, acceptance_date FROM apps.okc_change_party_role_v WHERE crt_id = :p_crt_id;
- Find roles accepted within a period:
SELECT crt_id, cpl_id, acceptance_date FROM apps.okc_change_party_role_v WHERE acceptance_date BETWEEN :p_start AND :p_end;
- Retrieve full audit context for a specific row:
SELECT row_id, crt_id, cpl_id, acceptance_date,
created_by, creation_date,
last_updated_by, last_update_date
FROM apps.okc_change_party_role_v
WHERE row_id = :p_rowid;
Because the view is a direct projection, these queries can be extended with standard EBS security predicates and joined to related contract change tables using CRT_ID and CPL_ID as needed. Performance characteristics mirror those of the base table, so indexing on the base columns remains the primary tuning consideration.
-
View for table OKC_CHANGE_PARTY_ROLE
APPS.OKC_CHANGE_PARTY_ROLE_V·↳ OKC_CHANGE_PARTY_ROLE·Explore OKC module →
-
View for table OKC_CHANGE_PARTY_ROLE
APPS.OKC_CHANGE_PARTY_ROLE_V·↳ OKC_CHANGE_PARTY_ROLE·Explore OKC module →
-
Defines which party in a contract is acting as the subject of a rule group and which is acting as the object of the rule group.
-
View: OKC_RG_PARTY_ROLES_V 12.2.2
View for table OKC_RG_MODE_PTY_ROLES
APPS.OKC_RG_PARTY_ROLES_V·↳ OKC_RG_PARTY_ROLES·Explore OKC module →
-
View: OKC_RG_PARTY_ROLES_HV 12.2.2
History view for OKC_RG_PARTY_ROLES.
APPS.OKC_RG_PARTY_ROLES_HV·↳ OKC_RG_PARTY_ROLES_H·Explore OKC module →
-
View: OKC_RG_PARTIES_BLK_V 12.1.1
APPS.OKC_RG_PARTIES_BLK_V·↳ FND_GLOBAL·↳ OKC_K_PARTY_ROLES_V·↳ OKC_RG_PARTY_ROLES_V·Explore OKC module →
-
View: OKC_RG_PARTIES_BLK_HV 12.1.1
APPS.OKC_RG_PARTIES_BLK_HV·↳ FND_GLOBAL·↳ OKC_K_PARTY_ROLES_HV·↳ OKC_RG_PARTY_ROLES_HV·Explore OKC module →
-
View: OKL_LA_ITEM_DTLS_UV 12.2.2
Item Details
APPS.OKL_LA_ITEM_DTLS_UV·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·↳ OKC_K_ITEMS·Explore OKL module →
-
Table: OKS_K_RES_TEMP 12.2.2
-
View: OKL_LA_ITEM_DTLS_UV 12.1.1
Item Details
APPS.OKL_LA_ITEM_DTLS_UV·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·↳ OKC_K_ITEMS·Explore OKL module →
-
Table: OKS_K_RES_TEMP 12.1.1
-
View: OKL_LA_KLE_VENDORS_UV 12.1.1
APPS.OKL_LA_KLE_VENDORS_UV·↳ OKC_K_PARTY_ROLES_B·↳ PO_VENDORS·Explore OKL module →
-
View: OKC_RG_PARTIES_LOV_V 12.2.2
APPS.OKC_RG_PARTIES_LOV_V·↳ FND_GLOBAL·↳ OKC_K_HEADERS_B·↳ OKC_K_PARTY_ROLES_V·Explore OKC module →
-
View: OKL_OR_SUBSIDY_REFUNDS 12.2.2
APPS.OKL_OR_SUBSIDY_REFUNDS·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
Relates a Contract Party to a Change Request.
-
View: OKL_OR_SUBSIDY_REFUNDS 12.1.1
APPS.OKL_OR_SUBSIDY_REFUNDS·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
Relates a Contract Party to a Change Request.
-
The parties related to the quote, could be one or more OKL contract party roles
-
The parties related to the quote, could be one or more OKL contract party roles
-
View: OKL_QUOTE_PARTIES_V 12.1.1
The parties related to the quote, could be one or more OKL contract party roles
APPS.OKL_QUOTE_PARTIES_V·↳ OKL_QUOTE_PARTIES·Explore OKL module →
-
User interface view for subsidies party payment details page
APPS.OKL_PARTY_PAYMENT_DTLS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: OKL_QUOTE_PARTIES_V 12.2.2
The parties related to the quote, could be one or more OKL contract party roles
APPS.OKL_QUOTE_PARTIES_V·↳ OKL_QUOTE_PARTIES·Explore OKL module →
-
View: OKL_ASSET_SUBSIDY_UV 12.1.1
User interface view for asset subsidies page
APPS.OKL_ASSET_SUBSIDY_UV·↳ OKC_K_LINES_B·↳ OKC_K_PARTY_ROLES_B·↳ OKC_LINE_STYLES_B·Explore OKL module →
-
Defines which party in a contract is acting as the subject of a rule group and which is acting as the object of the rule group.
-
View: OKL_K_LINE_VENDORS_UV 12.2.2
Lease Contract line vendor summary view
APPS.OKL_K_LINE_VENDORS_UV·↳ OKC_K_LINES_B·↳ OKC_K_PARTY_ROLES_B·↳ OKC_LINE_STYLES_B·Explore OKL module →
-
View: OKC_RG_PARTY_ROLES_V 12.1.1
View for table OKC_RG_MODE_PTY_ROLES
APPS.OKC_RG_PARTY_ROLES_V·↳ OKC_RG_PARTY_ROLES·Explore OKC module →
-
History Table for table OKC_RULE_GROUP_MODES
-
History Table for table OKC_RULE_GROUP_MODES
-
View: OKL_LA_KLE_VENDORS_UV 12.2.2
APPS.OKL_LA_KLE_VENDORS_UV·↳ OKC_K_PARTY_ROLES_B·↳ PO_VENDORS·Explore OKL module →
-
View: OKC_RG_PARTIES_BLK_V 12.2.2
APPS.OKC_RG_PARTIES_BLK_V·↳ FND_GLOBAL·↳ OKC_K_PARTY_ROLES_V·↳ OKC_RG_PARTY_ROLES_V·Explore OKC module →
-
This table is obsolete
-
View: OKC_RG_PARTIES_LOV_V 12.1.1
APPS.OKC_RG_PARTIES_LOV_V·↳ FND_GLOBAL·↳ OKC_K_HEADERS_B·↳ OKC_K_PARTY_ROLES_V·Explore OKC module →
-
View: OKC_RG_PARTIES_BLK_HV 12.2.2
APPS.OKC_RG_PARTIES_BLK_HV·↳ FND_GLOBAL·↳ OKC_K_PARTY_ROLES_HV·↳ OKC_RG_PARTY_ROLES_HV·Explore OKC module →
-
This table is obsolete
-
View: OKL_OR_AS_ADDON_V 12.1.1
APPS.OKL_OR_AS_ADDON_V·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·↳ OKC_K_ITEMS·Explore OKL module →
-
OKL Vendor billing view
APPS.OKL_LA_VENDOR_BILLING_UV·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·Explore OKL module →
-
OKL Vendor billing view
APPS.OKL_LA_VENDOR_BILLING_UV·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_ASSET_SUBSIDY_UV 12.2.2
User interface view for asset subsidies page
APPS.OKL_ASSET_SUBSIDY_UV·↳ OKC_K_LINES_B·↳ OKC_K_PARTY_ROLES_B·↳ OKC_LINE_STYLES_B·Explore OKL module →
-
User interface view that displays payment information for a context vendor
APPS.OKL_LA_VENDOR_PAYMENTS_UV·↳ AP_TERMS_TL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
User interface view that displays payment information for a context vendor
APPS.OKL_LA_VENDOR_PAYMENTS_UV·↳ AP_TERMS_TL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
User interface view to indicate passthrough vendors on a Passthrough Fee or Service
APPS.OKL_LA_PASSTHRU_VENDOR_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ FND_GLOBAL·Explore OKL module →
-
User interface view for vemdor (payment) details for a lessee(TCA party)
APPS.OKL_LESSEE_AS_VENDORS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: OKL_K_LINE_VENDORS_UV 12.1.1
Lease Contract line vendor summary view
APPS.OKL_K_LINE_VENDORS_UV·↳ OKC_K_LINES_B·↳ OKC_K_PARTY_ROLES_B·↳ OKC_LINE_STYLES_B·Explore OKL module →
-
View: OKC_ITEM_PARTYS_HV 12.2.2
History view for OKC_ITEM_PARTYS.
APPS.OKC_ITEM_PARTYS_HV·↳ OKC_ITEM_PARTYS_BH·↳ OKC_ITEM_PARTYS_TLH·Explore OKC module →
-
User interface view for subsidies party payment details page
APPS.OKL_PARTY_PAYMENT_DTLS_UV·↳ AP_LOOKUP_CODES·↳ AP_TERMS_TL·↳ ARP_ADDR_LABEL_PKG·Explore OKL module →
-
View: OKC_RG_PARTY_ROLES_HV 12.1.1
History view for OKC_RG_PARTY_ROLES.
APPS.OKC_RG_PARTY_ROLES_HV·↳ OKC_RG_PARTY_ROLES_H·Explore OKC module →
-
This is a mirror image of base table OKC_CONTACTS, please refer to the base table for detailed column level information.
-
User Interface view for passthrough evergreen term related pages
APPS.OKL_PSTHRU_EVRGRN_PMNT_DTL_UV·↳ OKL_PARTY_PAYMENT_DTLS·↳ OKL_PARTY_PAYMENT_HDR·↳ OKX_VENDORS_V·Explore OKL module →
-
An individual acting as a contact point or otherwise named in a Contract.
-
This is a mirror image of base table OKC_K_PARTY_ROLES_B, please refer to the base table for detailed column level information.