Results for “est_not_reqd”

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

Overview

APPS.CSD_GROUP_JOB_PARAM_TEMP_V is a reporting view in the Oracle E-Business Suite 12.1.1 and 12.2.2 Depot Repair (CSD) module. It presents a consolidated, denormalized projection of repair order groups that are eligible for WIP job creation, combining group-level attributes from CSD_REPAIR_ORDER_GROUPS with job parameter attributes from the temporary staging table CSD_GROUP_JOB_PARAM_TEMP. The view exists primarily to support the group job parameter workflow, where Depot Repair evaluates approved repair groups and their associated WIP jobs, and it is typically consumed by concurrent programs, forms, and downstream integrations that need a single query surface for repair-group-to-job data.

The defining filter on GROUP_APPROVAL_STATUS IN ('EST_NOT_REQD','PARTIAL_APPRD','APPROVED') is central to the view's purpose: it excludes groups whose estimate approval is still pending, allowing only groups that require no estimate (EST_NOT_REQD) or that have been partially or fully approved to flow into job processing. The REPAIR_MODE = 'WIP' and RECEIVED_QUANTITY = REPAIR_ORDER_QUANTITY predicates further restrict output to fully received, WIP-driven repairs.

Underlying Base Objects

The view is defined over four base objects referenced through APPS synonyms, plus two supporting packages:

• CSD_REPAIR_ORDER_GROUPS (CROG) — the driving table; supplies group identity, item, incident, approval status, repair mode, received and ordered quantities.
• CSD_GROUP_JOB_PARAM_TEMP (CGJP) — outer-joined on repair_group_id; supplies WIP job parameters where a job record exists, allowing groups without a staged job row to still appear.
• CSD_REPAIR_TYPES_VL (CRT) — the repair type lookup, filtered to references RR, ARR, WRL, WR, and SR.
• MTL_SYSTEM_ITEMS_KFV (MSI) — the item key flexfield view, joined on inventory item and restricted to the item-validation organization returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID.
• CS_STD and FND_GLOBAL — package dependencies used for organization context and item validation organization resolution.

Because the primary key column exposed is CROG.ROWID, the view is row-addressable but not inherently distinct at the group level where multiple job parameter rows may exist.

Key Columns

• GROUP_JOB_ID, REPAIR_GROUP_ID, REPAIR_GROUP_NUMBER — job and group identifiers.
• INVENTORY_ITEM_ID, PRODUCT (concatenated segments), ITEM_REVISION — item context.
• INCIDENT_ID — links the repair group to its service incident.
• ORGANIZATION_ID — the WIP organization for the job.
• JOB_TYPE, ROUTING_REFERENCE_ID, ALTERNATE_DESIGNATOR_CODE, ACCOUNTING_CLASS — WIP job definition attributes.
• JOB_STATUS_TYPE, START_DATE, COMPLETION_DATE — job scheduling and status.
• QUANTITY_RECEIVED, QUANTITY_SUBMITTED — job quantities.
• OBJECT_VERSION_NUMBER, PROCESS_ID — concurrency and processing control columns.

Common Use Cases and Queries

Typical uses include identifying groups ready for WIP job creation, auditing job parameter staging, and driving the group job concurrent process. A representative query:

SELECT repair_group_number, product, organization_id,
       job_type, job_status_type, quantity_submitted
FROM   apps.csd_group_job_param_temp_v
WHERE  org_id = :p_org_id;

To find groups approved and received but lacking a staged job record (the outer-join benefit):

SELECT repair_group_number, product
FROM   apps.csd_group_job_param_temp_v
WHERE  group_job_id IS NULL;

In 12.2.2 the object remains an APPS-owned view resolved through synonyms; because it references CS_STD and FND_GLOBAL, callers should ensure the correct organization context is initialized via FND_GLOBAL before querying.