Search Results po_rfqqt_document_types_all_v




Overview
Explore in AI Chat

Overview

The view APPS.PO_RFQQT_DOCUMENT_TYPES_ALL_V is an Oracle E-Business Suite Purchasing (PO) database object classified under the PO module in release 12.1.1 and 12.2.2. Its ETRM documentation carries the description "10SC ONLY - Retrofitted," indicating that the object was retrofitted into a 10SC (ten-schema customization) environment and is not a standard base object in every EBS deployment. The view exposes document type, document subtype, and quotation class metadata used to control how request-for-quotation (RFQ) and quotation documents are classified in the purchasing flow. Because it joins a translated document type table, an organization-specific document type base table, and the quotation class lookup view, it presents a language-resolved, organization-aware list of valid quotation classifications. Reporting layers, concurrent programs, and integration interfaces that must resolve the quotation class associated with an RFQ or quotation document can query this view rather than joining the underlying tables directly.

Underlying Base Objects

The documented base objects referenced by the view are FND_GLOBAL (package), PO_DOCUMENT_TYPES_ALL_TL (synonym), PO_DOCUMENT_TYPES_B (synonym), and PO_LOOKUP_CODES (view). The view text further clarifies the physical tables involved: PO_DOCUMENT_TYPES_ALL_TL supplies the language-dependent TYPE_NAME, PO_DOCUMENT_TYPES_ALL_B supplies DOCUMENT_TYPE_CODE, DOCUMENT_SUBTYPE, QUOTATION_CLASS_CODE, DISABLED_FLAG, and ORG_ID, and PO_LOOKUP_CODES supplies DISPLAYED_FIELD where the lookup type is QUOTATION CLASS. The language join is filtered by USERENV('LANG'), tied to the FND_GLOBAL session context, and the organization dimension is enforced by matching PODT.ORG_ID = PODB.ORG_ID. Records with DISABLED_FLAG = 'N' are retained, so only active document type and quotation class combinations are returned.

Key Columns

  • TYPE_NAME — the translated, user-facing name of the document type, resolved for the session language.
  • DOCUMENT_TYPE_CODE — the internal code identifying the purchasing document type (for example, quotation or RFQ variants).
  • DOCUMENT_SUBTYPE — the document subtype that narrows the type, used together with DOCUMENT_TYPE_CODE for the join to the translated table.
  • QUOTATION_CLASS_CODE — the quotation class associated with the document type; the value the user searched for and the central discriminator exposed by the view.
  • DISPLAYED_FIELD — the display value obtained from PO_LOOKUP_CODES for the QUOTATION CLASS lookup type.
  • ORG_ID — the operating unit or organization identifier that scopes the record.

Common Use Cases and Queries

Typical scenarios include validating quotation class codes during RFQ creation, populating list-of-values or reporting extracts for quotation documents, and resolving the displayable quotation class description for a given document type and operating unit. A representative query filtering on the searched column follows:

  • Retrieve all active quotation classes for an organization:
    SELECT type_name, document_type_code, document_subtype, quotation_class_code, displayed_field, org_id
    FROM apps.po_rfqqt_document_types_all_v
    WHERE org_id = :p_org_id
    ORDER BY type_name;
  • Resolve the display value for a specific quotation class code:
    SELECT quotation_class_code, displayed_field
    FROM apps.po_rfqqt_document_types_all_v
    WHERE quotation_class_code = :p_quotation_class_code
    AND org_id = :p_org_id;
  • Determine which document type and subtype pairs map to a quotation class for integration or interface lookups:
    SELECT document_type_code, document_subtype, quotation_class_code
    FROM apps.po_rfqqt_document_types_all_v
    WHERE org_id = :p_org_id;

Because the view depends on USERENV('LANG') and ORG_ID, consumers should always run it within a properly initialized EBS session and constrain by organization to obtain correct, language-appropriate results.