Search Results bar_code_label

Overview

The OE_PO_ENTER_RECEIPTS_V view, owned by the APPS schema within the ONT – Order Management product family, is a UNION-style reporting construct designed to support the "enter receipts to invoice" business flow in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to consolidate order-management sourcing information so that receipt and return transactions against customer orders can be presented in a uniform structure suitable for downstream receipt entry and invoicing. The view projects a consistent set of columns regardless of source transaction category, filling procurement-centric columns such as PO_HEADER_ID, PO_NUMBER, REQ_HEADER_ID, RCV_SHIPMENT_HEADER_ID, and VENDOR_ID with NULL or TO_NUMBER(NULL) placeholders while populating customer-order data from the order headers, lines, and transaction-type tables. This makes the view a normalized staging layer for Forms-based receipt entry screens and for integrations that must read receipt candidates from Order Management without directly navigating the OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL tables.

Underlying Base Objects

ETRM documents the following referenced base objects for the 12.2.2 definition: HZ_CUST_ACCOUNTS, HZ_PARTIES, MTL_CUSTOMER_ITEMS, MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_TL, MTL_UNITS_OF_MEASURE_TL, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_SYS_PARAMETERS (a package), OE_TRANSACTION_TYPES_ALL, and OE_TRANSACTION_TYPES_TL. The header and line tables provide the transactional backbone, supplying ship-to and ship-from organization identifiers, inventory item identifiers, item revisions, and order category codes. The MTL master tables enrich each row with item attributes required by receipt entry, including primary unit of measure and UOM class (via MTL_UNITS_OF_MEASURE_TL), segment1 item numbers, and inventory control flags such as lot, serial, revision, shelf-life, location, and subinventory control codes. The HZ_PARTIES and HZ_CUST_ACCOUNTS synonyms resolve the customer name presented in the SOURCE column, while OE_TRANSACTION_TYPES_ALL and its translation table supply ORDER_TYPE_CODE and ORDER_TYPE.

Key Columns

The view exposes an identity and sourcing block: LINE_CHKBOX, SOURCE_TYPE_CODE and RECEIPT_SOURCE_CODE (both hard-coded to 'CUSTOMER'), ORDER_TYPE_CODE, ORDER_TYPE, and SOURCE derived from the party name. A full set of NULL placeholder columns mirrors the purchasing receipt interface, including PO_HEADER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_NUMBER, PO_LINE_LOCATION_ID, PO_SHIPMENT_NUMBER, PO_RELEASE_ID, PO_RELEASE_NUMBER, REQ_HEADER_ID, REQ_NUMBER, REQ_LINE_ID, REQ_LINE, REQ_DISTRIBUTION_ID, RCV_SHIPMENT_HEADER_ID, RCV_SHIPMENT_NUMBER, RCV_SHIPMENT_LINE_ID, RCV_LINE_NUMBER, VENDOR_ID, VENDOR_SITE_ID, OUTSIDE_OPERATION_FLAG, ITEM_REV_CONTROL_FLAG_TO, and ITEM_REV_CONTROL_FLAG_FROM. Organization direction is captured by FROM_ORGANIZATION_ID (NVL of line then header SHIP_TO_ORG_ID) and TO_ORGANIZATION_ID (NVL of line then header SHIP_FROM_ORG_ID). Item and inventory attributes include ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, ITEM_REVISION, PRIMARY_UOM, PRIMARY_UOM_CLASS, ITEM_ALLOWED_UNITS_LOOKUP_CODE, ITEM_LOCATOR_CONTROL, RESTRICT_LOCATORS_CODE, RESTRICT_SUBINVENTORIES_CODE, SHELF_LIFE_CODE, SHELF_LIFE_DAYS, SERIAL_NUMBER_CONTROL_CODE, LOT_CONTROL_CODE, and ITEM_REV_CONTROL_FLAG_TO.

Common Use Cases and Queries

Typical usage includes populating receipt-entry LOVs and validation queries in Order Management, driving customer-return receipt processing into invoicing, and building reconciliation reports that compare customer-sourced receipts against purchasing receipts. The freight_bill_num search term does not correspond to any column in this view's documented projection; freight bill references reside in the purchasing receipt tables rather than in OE_PO_ENTER_RECEIPTS_V.

• Item verification prior to receipt: SELECT ITEM_NUMBER, ITEM_DESCRIPTION, PRIMARY_UOM, LOT_CONTROL_CODE, SERIAL_NUMBER_CONTROL_CODE FROM OE_PO_ENTER_RECEIPTS_V WHERE ITEM_NUMBER = :item;
• Order-type driven receipt selection: SELECT ORDER_TYPE_CODE, ORDER_TYPE, SOURCE, ITEM_NUMBER FROM OE_PO_ENTER_RECEIPTS_V WHERE ORDER_TYPE_CODE = :order_category;
• Organization routing check: SELECT FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID, ITEM_ID, ITEM_REVISION FROM OE_PO_ENTER_RECEIPTS_V WHERE FROM_ORGANIZATION_ID = :org_id;
• Integration extract: Applications join this view to OE_ORDER_LINES_ALL on ITEM_ID and organization columns to stage receipt records for external logistics systems.