Results for “repair_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OKL_AM_ASSET_CNDTN_LNS_UV view is a reporting and integration object in the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It is an APPS-owned, VALID database view that presents asset condition line information in a denormalized, user-friendly form. Asset condition lines in OKL capture the physical state of leased assets, including damage or wear identified during inspections, the recommended and approved repair actions, and the resulting repair cost estimates. The view consolidates the base transaction line data with its translated (language-dependent) descriptions, repair cost definitions, lookup-based code meanings, and tax/AR invoice linkage, so that the data can be consumed without joining numerous tables. This role is particularly valuable for operational reporting, ad-hoc querying, and integrations where a single, flat source of asset condition lines is required. The view is defined with outer joins to the repair cost tables, ensuring that condition lines without a defined repair cost are still returned.
Underlying Base Objects
The view is defined over a combination of base tables, synonyms, and a package. The core translatable line data is stored in OKL_ASSET_CNDTN_LNS_B (base) and OKL_ASSET_CNDTN_LNS_TL (translated), which are joined on ID and restricted to the session language via USERENV('LANG'). The condition header is sourced from OKL_ASSET_CNDTNS. Repair cost definitions are joined from OKL_REPAIR_COSTS_ALL_B (base) and OKL_REPAIR_COSTS_TL (translated), linked by RPC_ID with outer joins to allow optional repair costs. The OKL_TXL_AR_INV_LNS_B object is outer joined on ACN_ID_COST to supply the associated tax/AR invoice line cost. The FND_LOOKUPS view supplies three separate lookup meanings for status, condition, and damage type, while FND_GLOBAL (PACKAGE) provides the session environment used for language filtering.
Key Columns
The column set combines transactional identifiers, codes, descriptions, and rolled-up values:
- ROW_ID / ID – the physical rowid and the primary identifier of the condition line.
- OBJECT_VERSION_NUMBER – optimistic locking version used by the OKL application.
- ACD_ID – foreign key to the asset condition header (OKL_ASSET_CNDTNS).
- RPC_ID – the repair cost identifier that links the line to OKL_REPAIR_COSTS_ALL_B; this is the column users typically filter when tracing repair-cost-driven records.
- CTP_CODE, DTY_CODE, CDN_CODE, ACS_CODE – condition type, damage type, condition, and asset condition status codes.
- DAMAGE_DESCRIPTION / CLAIM_DESCRIPTION – translated narrative text from the TL table.
- ESTIMATED_REPAIR_COST / ACTUAL_REPAIR_COST – monetary estimates versus actuals.
- REPAIR_COST – cost from OKL_REPAIR_COSTS_ALL_B (aliased RPCB.COST).
- REPAIR_TYPE, PART_NAME, RECOMMENDED_REPAIR – repair categorization and recommended action.
- STATUS_DESC, CONDITION_DESC, DAMAGE_DESC – decoded lookup meanings.
- KLE_ID – lease identifier reference from the condition header.
- RPC_ORG_ID / ACN_ORG_ID – operating unit identifiers for multi-org security.
Common Use Cases and Queries
Typical use cases include asset condition reporting, repair cost analysis, and tracing repair cost references across condition lines. A frequent pattern is filtering by RPC_ID to identify all condition lines associated with a given repair cost definition:
SELECT id, acd_id, rpc_id, cdn_code, damage_description, estimated_repair_cost, repair_cost, status_desc FROM okl_am_asset_cndtn_lns_uv WHERE rpc_id = :p_rpc_id;SELECT acd_id, SUM(NVL(repair_cost,0)) total_repair FROM okl_am_asset_cndtn_lns_uv GROUP BY acd_id;SELECT id, rpc_org_id, acn_org_id, kle_id FROM okl_am_asset_cndtn_lns_uv WHERE damage_desc IS NOT NULL AND approved_yn = 'Y';
Because the view already resolves lookup descriptions and language-specific text, it is well suited to custom concurrent programs, OBIEE/BIP reports, and integration extracts that need repair-cost and damage details without complex multi-table joins.
-
APPS.OKL_AM_ASSET_CNDTN_LNS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_ASSET_CNDTNS·Explore OKL module →
-
View: CSD_RO_GROUP_DETAILS_V 12.1.1
Views that defines all the repair order details for a group.
APPS.CSD_RO_GROUP_DETAILS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
View: CSD_JOB_HEADER_V 12.2.2
This view gets the header information for the job to be submitted. This view is used by the header block of the submit Repair Job screen. This is specific to the header screen brought up, when navigate from the Repair order Workbench.
APPS.CSD_JOB_HEADER_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CS_INCIDENTS_ALL_B·Explore CSD module →
-
View: CSD_JOB_HEADER_V 12.1.1
This view gets the header information for the job to be submitted. This view is used by the header block of the submit Repair Job screen. This is specific to the header screen brought up, when navigate from the Repair order Workbench.
APPS.CSD_JOB_HEADER_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CS_INCIDENTS_ALL_B·Explore CSD module →
-
Translatable columns from OKL_REPAIR_COSTS_B, per MLS standards
-
Translatable columns from OKL_REPAIR_COSTS_B, per MLS standards
-
View: CSD_RO_GROUP_DETAILS_V 12.2.2
Views that defines all the repair order details for a group.
APPS.CSD_RO_GROUP_DETAILS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
View: OKL_REPAIR_COSTS_V 12.1.1
Setup table to store types of repair and a recommended cost applicable to asset condition repairs
APPS.OKL_REPAIR_COSTS_V·↳ OKL_REPAIR_COSTS_B·↳ OKL_REPAIR_COSTS_TL·Explore OKL module →
-
View: OKL_REPAIR_COSTS_V 12.2.2
Setup table to store types of repair and a recommended cost applicable to asset condition repairs
APPS.OKL_REPAIR_COSTS_V·↳ OKL_REPAIR_COSTS_B·↳ OKL_REPAIR_COSTS_TL·Explore OKL module →
-
Views that fetches all the repair order groups for service request.
APPS.CSD_REPAIR_ORDER_GROUPS_V·↳ CSD_PROCESS_UTIL·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
APPS.OKL_AM_ASSET_CNDTN_LNS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_ASSET_CNDTNS·Explore OKL module →
-
Views that fetches all the repair order groups for service request.
APPS.CSD_REPAIR_ORDER_GROUPS_V·↳ CSD_PROCESS_UTIL·↳ CSD_REPAIR_ORDER_GROUPS·↳ CSD_REPAIR_TYPES_VL·Explore CSD module →
-
View: CSD_REPAIR_JOBS_V 12.2.2
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_REPAIR_JOBS_V 12.1.1
The view for getting repair orders with service request information.
APPS.CSD_REPAIR_JOBS_V·↳ CSD_REPAIRS·↳ CSD_REPAIR_TYPES_VL·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
VIEW: APPS.CSD_RULES_B_DFV 12.1.1
-
VIEW: APPS.CSD_RULES_B_DFV 12.2.2
-
VIEW: APPS.CSD_JOB_HEADER_V 12.1.1
-
VIEW: APPS.CSD_RULES_B_DFV 12.1.1
-
Defaulting Attributes for Repair Order Entity
-
VIEW: APPS.CSD_JOB_HEADER_V 12.2.2
-
Defaulting Attributes for Repair Order Entity
-
VIEW: APPS.CSD_JOB_HEADER_V 12.2.2
-
VIEW: APPS.CSD_JOB_HEADER_V 12.1.1
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.1.1
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.2.2
-
VIEW: APPS.CSD_REPAIR_JOBS_V 12.1.1