Results for “csd_group_job_param_temp_v”

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

Overview

The view APPS.CSD_GROUP_JOB_PARAM_TEMP_V is a reporting and integration construct within the Oracle E-Business Suite Depot Repair (CSD) module. It is defined as a database view over the base entity CSD_GROUP_JOB_PARAM_TEMP, joined to several supporting objects, and exposes consolidated job and repair-group information for depot repair work orders that are executed in a WIP (Work in Process) environment. The view is maintained in the APPS schema and carries a VALID status in both Release 12.1.1 and 12.2.2.

Its primary role is to present group job parameters alongside the parent repair order group, the repair type, and the concatenated item description, so that downstream reports, concurrent programs, and integration interfaces can retrieve job parameter data without navigating multiple base tables. Because the view filters repair types and approval statuses, it surfaces only rows that are eligible for job creation and processing, making it particularly suitable for populating repair job and routing reference data.

Underlying Base Objects

The view is defined over the following documented objects:

• CSD_REPAIR_ORDER_GROUPS (synonym) — the repair order group header, aliased CROG.
• CSD_REPAIR_TYPES_VL (view) — the repair type lookup, aliased CRT.
• MTL_SYSTEM_ITEMS_KFV (synonym) — the item key flexfield view, aliased MSI, providing concatenated segments.
• CSD_GROUP_JOB_PARAM_TEMP (synonym) — the group job parameter base entity, aliased CGJP.
• CS_STD (package) — used in the join predicate to return the item validation organization.
• FND_GLOBAL (package) — referenced in the view definition for environment context.

The join is driven from CSD_REPAIR_ORDER_GROUPS, with an outer join (indicated by the (+) operator) from CSD_GROUP_JOB_PARAM_TEMP on REPAIR_GROUP_ID. The repair type is constrained to the reference codes RR, ARR, WRL, WR, and SR, and repair groups are restricted to approval statuses EST_NOT_REQD, PARTIAL_APPRD, and APPROVED, where received quantity equals repair order quantity and the repair mode is WIP.

Key Columns

The view exposes twenty columns. Principal among them:

• ROW_ID — the row identifier derived from CSD_REPAIR_ORDER_GROUPS.
• GROUP_JOB_ID, REPAIR_GROUP_ID, INVENTORY_ITEM_ID — primary keys linking jobs to groups and items.
• PRODUCT — the concatenated item segments from MTL_SYSTEM_ITEMS_KFV.
• REPAIR_GROUP_NUMBER, INCIDENT_ID — human-readable group reference and service incident link.
• ORGANIZATION_ID, JOB_TYPE, JOB_STATUS_TYPE, ACCOUNTING_CLASS — job execution and accounting context.
• ROUTING_REFERENCE_ID — the routing reference associated with the group job parameter; this is the column most commonly targeted when users search for routing reference data.
• ALTERNATE_DESIGNATOR_CODE, ITEM_REVISION — item revision control attributes.
• START_DATE, COMPLETION_DATE, QUANTITY_RECEIVED, QUANTITY_SUBMITTED — scheduling and quantity metrics.
• OBJECT_VERSION_NUMBER, PROCESS_ID — concurrency and process tracking attributes.

Common Use Cases and Queries

This view is typically queried to enumerate eligible group jobs with their routing references, or to reconcile job parameters against repair groups prior to WIP job creation. A representative query follows:

• SELECT repair_group_number, group_job_id, product, job_type, routing_reference_id, job_status_type FROM csd_group_job_param_temp_v WHERE routing_reference_id IS NOT NULL; — retrieves all group jobs with an assigned routing reference.
• SELECT repair_group_number, organization_id, quantity_received, quantity_submitted FROM csd_group_job_param_temp_v WHERE repair_group_id = :p_repair_group_id; — scopes results to a single repair group.

Because the view already enforces repair type, approval status, quantity, and repair mode predicates, consumers need not reapply those filters, reducing the risk of selecting ineligible jobs. It should be treated as a read-only reporting surface over the temporary group job parameter data.