Search Results po_document_types_all_b




Overview
Explore in AI Chat

Overview

PO_DOCUMENT_TYPES_ALL_B is a Purchasing (PO) module table that stores document type definitions in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides in the PO schema and is defined as a valid, standalone table with no foreign-key dependencies documented through the heuristic Data Vault classification. Each row describes a purchasable document category (for example, purchase orders, quotations, requisitions, or agreements) together with the configuration that governs how that document type behaves during approval, forwarding, and generation.

Because the table is classified as standalone, it functions naturally as a hub of reference data: it holds the authoritative set of document type and subtype combinations against which transactional purchasing documents are validated. The _ALL suffix indicates that the table is multi-organization aware, since ORG_ID participates in the primary key.

Key Information Stored

The primary key PO_DOCUMENT_TYPES_ALL_B_PK is a composite of DOCUMENT_TYPE_CODE, DOCUMENT_SUBTYPE, and ORG_ID. The unique index PO_DOCUMENT_TYPES_ALL_B_U1 adds ZD_EDITION_NAME, forming the business-key candidate for this table in the extended (ZD) edition model. The most significant columns are:

Common Use Cases and Queries

Typical usage lists the active document types available for an operating unit, checks whether a preparer can self-approve, or joins workflow and AME configuration for approval diagnostics.

  • Enumerate active types: SELECT document_type_code, document_subtype, disabled_flag FROM po.po_document_types_all_b WHERE org_id = :org_id AND disabled_flag = 'N';
  • Approval governance: query ame_transaction_type, wf_approval_itemtype, and wf_approval_process for a given type/subtype.
  • Security review: filter on security_level_code and access_level_code.
  • Template auditing: join document_template_code and contract_template_code against template tables.

Related Objects