Search Results sample_spec_disposition

Overview

PMITS_QC_SAMPLES_V is an Oracle EBS Applications (APPS) schema view that exposes quality control sample information for the Process Manufacturing Intelligence (PMI) module. It is a reporting and integration layer over the process manufacturing quality sample tables (GMD_SAMPLES and related specification disposition objects), enriched with descriptive lookups and denormalized foreign key descriptions from purchasing, receiving, order management, human resources, and customer master data.

The view presents one row per sampling event step, keyed primarily by SAMPLING_EVENT_ID and STEP_NO. It combines the operational quality sample record with human-readable meaning columns (suffix _DISP), which decode internal codes into display values. This design makes the view immediately consumable by BI Publisher reports, Discoverer workbooks, OBIEE/OTBI extracts, and custom concurrent programs without additional lookup joins.

The user search term source_disp maps directly to a column exposed by this view: QC_SOURCE.MEANING SOURCE_DISP. This column resolves the sample SOURCE code into its display meaning by joining to the GEM_LOOKUPS view, allowing users to filter or group samples by their originating source in a readable form.

Underlying Base Objects

The view draws from a broad set of documented base objects. Core process manufacturing objects include GMD_SAMPLES, GMD_SAMPLE_SPEC_DISP, GMD_OPERATIONS, GMD_RECIPES_B, GMD_ROUTINGS_B, GMD_ALL_SPEC_VRS, GMD_EVENT_SPEC_DISP, FM_FORM_MST_B, and GME_BATCH_HEADER. These supply the sample, specification, recipe, routing, formula, and batch context.

Descriptive and transactional enrichment comes from purchasing and receiving objects (PO_HEADERS_ALL, PO_LINES_ALL, PO_VENDORS, PO_VENDOR_SITES_ALL, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES), order management (OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_TRANSACTION_TYPES), customer and party data (HZ_CUST_ACCOUNTS_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES), and HR (HR_OPERATING_UNITS). Lookup translations rely on GEM_LOOKUPS, while FND_GLOBAL, PMI_SECURITY_PKG, and related security objects enforce organization-level access and multilingual meaning resolution.

The joins are implemented as ANSI or Oracle-style equijoins on the foreign keys carried in GMD_SAMPLES, producing a wide, report-ready projection.

Key Columns

• SAMPLING_EVENT_ID, STEP_NO, STEP_ID, SAMPLE_ID, SAMPLE_NO, SAMPLE_DESC — Sampling event and sample identification.
• SOURCE, SOURCE_DISP — Internal source code and its display meaning (from GEM_LOOKUPS).
• QC_LAB_ORGN_CODE, ORG_ID — Quality lab and inventory organization context.
• ITEM_ID, LOT_ID, LOT_NO, BATCH_ID, SUBLOT_NO — Material, lot, and batch identifiers.
• RECIPE_ID, FORMULA_ID, ROUTING_ID, OPRN_ID — Process definition linkage.
• DATE_DRAWN, SAMPLER_ID, SAMPLE_APPROVER_ID, INV_APPROVER_ID — Sampling workflow and approvals.
• SAMPLE_QTY, SAMPLE_UOM, PRIORITY — Quantitative and priority attributes.
• SAMPLE_INV_TRANS_IND, SAMPLE_INV_TRANS_IND_DISP, DELETE_MARK, DELETE_MARK_DISP — Decoded status indicators.
• SUPPLIER_CODE, SUPPLIER_NAME, SUPPLIER_SITE, PO_NUMBER, PO_LINE_NUMBER, RECEIPT_NUMBER, RECEIPT_LINE_NUMBER — Purchasing and receiving traceability.
• ORDER_NUMBER, ORDER_TYPE, ORDER_LINE_NUMBER, CUSTOMER_NAME, SHIP_TO_SITE_NAME — Sales order and shipment destination.
• BATCH_NO, PLANT_CODE, FORMULA_NO, FORMULA_VERS, RECIPE_NO, ROUTING_NO, OPERATING_UNIT_NAME — Manufacturing and operating unit descriptions.
• SAMPLE_SPEC_DISPOSITION, SPEC_NAME — Specification disposition outcome.

Common Use Cases and Queries

Typical uses include QC sample tracking dashboards, supplier quality analysis, batch disposition reporting, and specification conformance extracts. Because SOURCE_DISP is exposed directly, filtering by sample source requires no lookup join.

• Count samples by decoded source for a period:

SELECT source_disp, COUNT(*) sample_count
FROM   apps.pmits_qc_samples_v
WHERE  date_drawn BETWEEN :p_from AND :p_to
GROUP  BY source_disp
ORDER  BY sample_count DESC;

• Supplier quality traceability for received lots:

SELECT sample_no, supplier_name, po_number, receipt_number,
       lot_no, sample_spec_disposition
FROM   apps.pmits_qc_samples_v
WHERE  supplier_id IS NOT NULL
AND    delete_mark_disp = 'No';

• Pending sample approvals by analyst:

SELECT sample_no, sampler_id, sample_approver_id,
       priority, source_disp
FROM   apps.pmits_qc_samples_v
WHERE  sample_inv_trans_ind_disp = 'No';

Note that FND_GLOBAL and PMI_SECURITY_PKG references indicate the view is organization-secured; queries should be run in the correct operating unit context to return the intended data set.