Search Results spec_type_disp




Overview
Explore in AI Chat

Overview

APPS.PMITS_QC_ALL_SPEC_VRS_V is a database view in the Oracle E-Business Suite quality module, delivered under the APPS schema as part of the Oracle Quality / Process Manufacturing (OPM) quality integration. In ETRM and Oracle EBS 12.1.1 and 12.2.2, the object name indicates its lineage: the PMITS prefix denotes the Process Manufacturing Intelligence/Integration layer, QC denotes Quality Control, ALL_SPEC_VRS denotes the consolidated specification-versions entity, and the trailing _V identifies it as a view.

The view exposes specification version attributes together with a set of user-facing indicator and description fields. The most significant of these is SPEC_TYPE_DISP, the display-oriented spec type column that the user searched for. The view is primarily a presentation and integration object, intended to feed reports, concurrent programs, and external interfaces with a consistent, ready-to-display representation of specification version data.

Underlying Base Objects

According to documented ETRM 12.2.2 metadata, the only referenced base object for this view is DUAL (SYNONYM). The view is therefore defined as a SELECT ... FROM DUAL construct. In the delivered ETRM documentation, this appears as a stub definition populated with literal placeholders such as 1, 'abc', SYSDATE, and 'a' in place of the real column expressions.

This pattern is common in ETRM documentation exports, where the extraction process replaces sensitive or environment-specific SQL with dummy literals while preserving column aliases and ordering. The practically important point is that, in a functioning instance, the view logically resolves against specification and specification-version data in the quality schema; the delivered documentation records only the DUAL synonym as the base object. Consultants relying solely on ETRM should treat the base-object listing as incomplete and verify the actual view text against the target database (for example, via DBA_VIEWS or DBMS_METADATA.GET_DDL).

Key Columns

The column aliases preserved in the documentation reveal the semantic content of the view. Notable columns include:

The remaining columns are numeric and date attributes mixed with character identifiers; in the documented stub they appear as 1 and SYSDATE literals. The _DISP suffix across the indicator columns signals that values are pre-formatted for presentation rather than raw stored flags.

Common Use Cases and Queries

Because the view surfaces ready-to-display specification attributes, it is typically consumed by quality specification inquiry screens, custom reports, and inbound/outbound integration extracts. A representative query retrieving the spec type display value and shipment/invoice COA flags is:

  • SELECT spec_type_disp, coa_at_ship_ind_disp, coa_at_invoice_ind_disp, coa_req_from_supl_ind_disp FROM apps.pmits_qc_all_spec_vrs_v;
  • SELECT spec_type_disp, control_batch_step_ind_disp FROM apps.pmits_qc_all_spec_vrs_v WHERE sample_inv_trans_ind_disp = 'Y';

Before using the view in a 12.1.1 or 12.2.2 instance, confirm that the APPS synonym is valid, check for editioning or customisations, and reconcile actual column names against the target database, since the ETRM metadata documents the view only as a DUAL-based placeholder.