Results for “csf_labor_reason”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CSF_DEBRIEF_LAB_LINES_V is a reporting and integration view that exposes labor debrief line information from the Oracle E-Business Suite Field Service (formerly TeleService / Service) module. It is defined over the CSF_DEBRIEF_LINES base entity and enriches each labor line with descriptive context drawn from transaction types, item master data, billing type categories, and FND lookup values. In EBS 12.1.1 and 12.2.2, the view serves as the principal read-only interface for external charge-upload processes, service billing reconciliation, and custom operational reports that require a denormalized picture of reported labor, mileage, and equipment usage against a debrief header.

The view is of particular interest to users searching on csf_labor_reason, because it is one of the very few documented objects in the ETRM data model that joins the CSF_DEBRIEF_LINES.LABOR_REASON_CODE column to the FND_LOOKUPS view using the lookup type CSF_LABOR_REASON. This makes the view the canonical source for resolving a labor reason code into its user-facing meaning.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects:

• CSF_DEBRIEF_LINES (synonym) — the primary fact entity; source of every debrief attribute, including labor start/end dates, quantity, mileage, and the labor reason code.
• CS_TRANSACTION_TYPES_VL (view) — supplies transaction_type_id, name, and description for the debrief line's transaction type.
• CS_BILLING_TYPE_CATEGORIES (synonym) — filters items to those whose billing category is 'L' (labor), pairing material_billable_flag with billing type.
• MTL_SYSTEM_ITEMS_B_KFV (view) — the key-flex item view, used to validate the inventory item and its billable flag within the item validation organization.
• FND_LOOKUPS (view) — a non-enforced outer join (via '+') on lookup_type 'CSF_LABOR_REASON', providing the meaning of the labor reason code.
• CS_STD (package) — supplies get_item_valdn_orgzn_id, which returns the validation organization id.
• FND_GLOBAL (package) — supplies session context used within the underlying logic.

The view is implemented as a UNION of at least two branches, both projecting the same column list. Each branch applies the same join chain and the same outer join to FND_LOOKUPS, which preserves labor lines even where no reason code is assigned.

Key Columns

• Debrief_Line_Id / Debrief_Header_Id — primary and foreign key identifiers linking the line to its debrief header.
• Channel_Code — the origin channel of the debrief (e.g., mobile, web).
• Service_Date, labor_start_date, labor_end_date — the service and labor interval timestamps.
• Inventory_Item_Id, uom_code, quantity — the item, unit of measure, and labor quantity.
• starting_mileage, ending_mileage — odometer readings captured for the labor line.
• labor_reason_code, meaning — the reason code and its translated meaning from FND_LOOKUPS (CSF_LABOR_REASON).
• transaction_type_id, name, description — the transaction type metadata from CS_TRANSACTION_TYPES_VL.
• Charge_Upload_Status, Charge_Upload_Msg_Code, Charge_Upload_Message, error_text — status and diagnostic fields for the charge-upload interface.
• Attribute1–Attribute15, Attribute_Category — the standard DFF columns for extensibility.
• business_process_id — identifies the business process associated with the line.
• Created_By, Creation_Date, Last_Updated_By, Last_Update_Date, Last_Update_Login — standard WHO columns.

Common Use Cases and Queries

Typical uses include labor reason analysis, charge-upload error triage, and debrief line reporting. A representative query for labor reason reporting is:

• SELECT debrief_line_id, labor_reason_code, meaning, service_date, quantity FROM apps.csf_debrief_lab_lines_v WHERE labor_reason_code IS NOT NULL;
• SELECT debrief_header_id, SUM(quantity) FROM apps.csf_debrief_lab_lines_v GROUP BY debrief_header_id;
• SELECT debrief_line_id, Charge_Upload_Status, Charge_Upload_Message, error_text FROM apps.csf_debrief_lab_lines_v WHERE Charge_Upload_Status = 'ERROR';

Because the view filters to billing category 'L' in the first union branch, it is best treated as a labor-specific slice rather than a comprehensive debrief line listing.