Results for “authoring_org_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_AM_CONTRACT_ADV_SEARCH_UV is a valid APPS-owned view within the OKL – Leasing and Finance Management product family, deployed in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the advanced search interface layer for lease and finance contract authoring records, exposing a normalized projection of contract, asset, status, and party attributes for query and integration purposes.
In the documented ETRM 12.2.2 metadata, the view text resolves to a deliberately empty result set: the projection selects NULL for every column and filters the underlying union view with the predicate OCP.ID = 0. This confirms that OKL_AM_CONTRACT_ADV_SEARCH_UV functions as a structural placeholder — a typed signature that downstream consumers (Oracle Forms LOVs, OAF advanced search regions, or custom reports) can bind against even when no qualifying rows exist. It is not a data-bearing reporting object on its own; it depends on OKL_AM_CONTRACT_PARTIES_UV for its column shape.
Underlying Base Objects
The documented referenced base objects are:
- OKL_AM_CONTRACT_PARTIES_UV (VIEW) — the primary source in the FROM clause, aliased OCP. It supplies all projected columns, including AUTHORING_ORG_ID and PARTY_NAME.
- FND_GLOBAL (PACKAGE) — the standard Oracle EBS context package, typically invoked in the full union view for organization and responsibility resolution.
- OKC_UTIL (PACKAGE) — the Contracts Core utility package, providing shared contract lookups (status meaning, party, and numbering logic).
Function-oriented joins against OKL_AM_CONTRACT_PARTIES_UV can be leveraged in custom extensions, though the shipped view intentionally returns zero rows.
Key Columns
- CHR_ID — identifier for the change request or contract header reference.
- ASSET_NUMBER — leased asset number tied to the contract.
- SERIAL_NUMBER — manufacturer or system serial number for the asset.
- CONTRACT_NUMBER — the contract's business-facing number.
- START_DATE / END_DATE — effective term boundaries of the contract.
- STS_CODE — status code (typically mapped to FND lookup values).
- STS_MEANING — decoded status description.
- AUTHORING_ORG_ID — the organization Owning/authoring the contract; used for multi-org security filtering and is the field most frequently queried by users.
- PARTY_NAME — the customer or party name associated with the contract.
Common Use Cases and Queries
Because the shipped view returns no rows, it is typically referenced as a template. A representative query matches the documented projection:
SELECT chr_id, asset_number, serial_number, contract_number,
start_date, end_date, sts_code, sts_meaning,
authoring_org_id, party_name
FROM apps.okl_am_contract_adv_search_uv;
To obtain actual data — the standard approach for advanced search on authoring_org_id — query the underlying union view directly:
SELECT contract_number, authoring_org_id, party_name
FROM apps.okl_am_contract_parties_uv
WHERE authoring_org_id = :p_org_id;
Typical scenarios include building an advanced search LOV for lease contracts by authoring organization, feeding a multi-org secured report, and validating that contract rows exist for a given operating unit before invoking downstream OKL APIs. Developers extending the view should preserve the AUTHORING_ORG_ID column contract, since Forms and OAF search regions bind to it by name.
-
APPS.OKL_AM_CONTRACT_ADV_SEARCH_UV·↳ FND_GLOBAL·↳ OKC_UTIL·↳ OKL_AM_CONTRACT_PARTIES_UV·Explore OKL module →
-
APPS.OKL_AM_CONTRACT_ADV_SEARCH_UV·↳ FND_GLOBAL·↳ OKC_UTIL·↳ OKL_AM_CONTRACT_PARTIES_UV·Explore OKL module →
-
APPS.MTL_SERVICE_CONTRACTS_V·↳ OKC_K_HEADERS_ALL_B·↳ OKC_STATUSES_B·Explore INV module →
-
View: INV_3PL_CLIENTS_V 12.2.2
APPS.INV_3PL_CLIENTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ MTL_BILLING_RULE_HEADERS_VL·Explore INV module →
-
View: OKI_PERF_MEASURES_V 12.1.1
Holds the values for the Key Performance Indicators.
APPS.OKI_PERF_MEASURES_V·↳ OKI_PERF_MEASURES·Explore OKI module →
-
View: INV_3PL_CONTRACTS_V 12.2.2
APPS.INV_3PL_CONTRACTS_V·↳ HR_GENERAL·↳ HR_OPERATING_UNITS·↳ HR_SECURITY·Explore INV module →
-
Summarized forecast and booked contract information by operating unit and period.
-
View: OKC_USER_BINS_V 12.2.2
View for Table OKC_USER_BINS
APPS.OKC_USER_BINS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKC module →
-
View: OKL_LA_HEADERS_UV 12.1.1
User Interface View for getting Oracle Contracts for Lease header information
APPS.OKL_LA_HEADERS_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_STATUSES_TL·Explore OKL module →
-
View: OKC_REPORT_XSL_V 12.2.2
Used in Contract Printing. Keeps stylesheet for sql-xml-xsl-html contract printing.
APPS.OKC_REPORT_XSL_V·↳ OKC_CONTEXT·↳ OKC_REPORT_XSL_B·↳ OKC_REPORT_XSL_TL·Explore OKC module →
-
APPS.OKL_ACCRUAL_OVERRIDE_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_PARTY_ROLES_B·↳ OKL_ACCOUNTING_UTIL·Explore OKL module →
-
Used for Contract Printing. Keeps stylesheet that drives XSLT in sql-xml-xsl-html report.
-
Holds information about the value of renewed contracts on a historical basis.
-
Holds information about renewal contracts by contract status.
-
View: OKI_WIP_BY_CUSTOMERS_V 12.1.1
Holds information about renewals by customer for a given period.
APPS.OKI_WIP_BY_CUSTOMERS_V·↳ OKI_WIP_BY_CUSTOMERS·Explore OKI module →
-
View: OKE_K_HEADERS_ORGNZR_V 12.1.1
Contract listing view for Contract Organizer tree
APPS.OKE_K_HEADERS_ORGNZR_V·↳ FND_LOOKUP_VALUES_VL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·Explore OKE module →
-
View: OKE_K_HEADERS_ORGNZR_V 12.2.2
Contract listing view for Contract Organizer tree
APPS.OKE_K_HEADERS_ORGNZR_V·↳ FND_LOOKUP_VALUES_VL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·Explore OKE module →
-
View: OKI_RENEWAL_AGING_V 12.1.1
Holds the values for the aging of renewals by time period.
APPS.OKI_RENEWAL_AGING_V·↳ OKI_RENEWAL_AGING·Explore OKI module →
-
Table: OKS_K_RES_TEMP 12.2.2
-
Table: OKI_SRM_019_MV 12.1.1
-
Holds the values for the aging of renewals by time period.
-
View: OKI_YOY_RENEWAL_AMT_V 12.1.1
Holds information about the value of renewed contracts on a historical basis.
APPS.OKI_YOY_RENEWAL_AMT_V·↳ OKI_YOY_RENEWAL_AMT·Explore OKI module →
-
Holds information about renewal contracts by contract status.
APPS.OKI_RENEW_BY_STATUSES_V·↳ OKI_RENEW_BY_STATUSES·Explore OKI module →
-
Summarized information about contract lines that have expired without being renewed.
-
Table: OKI_SRM_020_MV 12.1.1
-
View: OKX_COVERED_ASSET_V 12.1.1
This view stores information about financial asset lines
APPS.OKX_COVERED_ASSET_V·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKL_LA_SRV_COV_AST_UV 12.2.2
APPS.OKL_LA_SRV_COV_AST_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View: OKX_COVERED_ASSET_V 12.2.2
This view stores information about financial asset lines
APPS.OKX_COVERED_ASSET_V·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
Table: OKI_SRM_040_MV 12.1.1
-
View: OKC_SALES_TEMPLATES_V 12.1.1
APPS.OKC_SALES_TEMPLATES_V·↳ OKC_CLASSES_B·↳ OKC_K_HEADERS_V·↳ OKC_K_VERS_NUMBERS·Explore OKC module →
-
View: OKC_SALES_TEMPLATES_V 12.2.2
APPS.OKC_SALES_TEMPLATES_V·↳ OKC_CLASSES_B·↳ OKC_K_HEADERS_V·↳ OKC_K_VERS_NUMBERS·Explore OKC module →
-
Used for Contract Printing. Keeps stylesheet that drives XSLT in sql-xml-xsl-html report.
-
Table: OKI_SRM_018_MV 12.1.1
-
User Interface view for covered assets LOV on fee page
APPS.OKL_LA_FEE_COVERED_ASSET_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View: OKL_SEC_HEADERS_UV 12.2.2
User Interface view for securitizaton headers
APPS.OKL_SEC_HEADERS_UV·↳ FND_CURRENCIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKL module →
-
Table: OKI_SRM_028_MV 12.1.1
-
View: OKI_FORECAST_BY_ORGS_V 12.1.1
Summarized forecast and booked contract information by operating unit and period.
APPS.OKI_FORECAST_BY_ORGS_V·↳ OKI_FORECAST_BY_ORGS·Explore OKI module →
-
Table: OKI_SRM_012_MV 12.1.1
-
View: OKL_LA_TRADEIN_LOV_UV 12.1.1
Trade-in Asset Association LOV view
APPS.OKL_LA_TRADEIN_LOV_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View: OKL_POOL_CONTRACTS_UV 12.1.1
Securitization - Pool Contracts UI view
APPS.OKL_POOL_CONTRACTS_UV·↳ OKC_K_HEADERS_B·↳ OKC_RULES_B·↳ OKC_RULE_GROUPS_B·Explore OKL module →
-
View: OKI_RNW_BY_STS_DTL_V 12.1.1
Summarized information about renewal contracts, by status and General Ledger period.
APPS.OKI_RNW_BY_STS_DTL_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ GL_PERIODS·Explore OKI module →
-
View: OKL_POOL_CONTRACTS_UV 12.2.2
Securitization - Pool Contracts UI view
APPS.OKL_POOL_CONTRACTS_UV·↳ OKC_K_HEADERS_B·↳ OKC_RULES_B·↳ OKC_RULE_GROUPS_B·Explore OKL module →
-
Holds the values for the Key Performance Indicators.
-
View: OKL_LA_HEADERS_UV 12.2.2
User Interface View for getting Oracle Contracts for Lease header information
APPS.OKL_LA_HEADERS_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·↳ OKC_STATUSES_TL·Explore OKL module →
-
APPS.OKL_ACCRUAL_OVERRIDE_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_PARTY_ROLES_B·↳ OKL_ACCOUNTING_UTIL·Explore OKL module →
-
View: OKC_REPORT_XSL_V 12.1.1
Used in Contract Printing. Keeps stylesheet for sql-xml-xsl-html contract printing.
APPS.OKC_REPORT_XSL_V·↳ OKC_CONTEXT·↳ OKC_REPORT_XSL_B·↳ OKC_REPORT_XSL_TL·Explore OKC module →
-
View: OKC_USER_BINS_V 12.1.1
View for Table OKC_USER_BINS
APPS.OKC_USER_BINS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKC module →
-
OKL Link Service Line LOV View
APPS.OKL_LA_LINK_SERVICE_UV9·↳ CSI_ITEM_INSTANCES·↳ HZ_PARTIES·↳ MTL_SYSTEM_ITEMS_B·Explore OKL module →
-
View: OKL_SEC_HEADERS_UV 12.1.1
User Interface view for securitizaton headers
APPS.OKL_SEC_HEADERS_UV·↳ FND_CURRENCIES_VL·↳ OKC_K_HEADERS_B·↳ OKC_K_HEADERS_TL·Explore OKL module →