Results for “receipt_required_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RCV_SUPPLIERS_VAL_V is a validation view owned by the APPS schema within the Oracle E-Business Suite Purchasing (PO) module. It presents supplier (vendor) master information required by receiving and purchasing validation logic, exposing a curated set of supplier attributes alongside a decoded hold status. The view is defined over PO_VENDORS — the primary supplier definition entity — joined to the FND_LOOKUPS view, which supplies the descriptive meaning behind the supplier hold indicator. Rather than surfacing raw lookup codes, the view translates the internal HOLD_FLAG into a human-readable HOLD_STATUS via the YES_NO lookup type.

Because it renders supplier data in a validated, interpretation-ready form, the view is commonly referenced by receiving and purchasing flows that need to confirm a supplier is active and to determine whether that supplier is currently placed on hold. In EBS 12.1.1 and 12.2.2 the view is documented as VALID in the APPS schema, indicating it is a supported and enabled object within the ETRM metadata.

Underlying Base Objects

The documented referenced objects are FND_GLOBAL (PACKAGE), FND_LOOKUPS (VIEW), and PO_VENDORS (VIEW). The view's SELECT joins PO_VENDORS (aliased POV) to FND_LOOKUPS (aliased FL) on the condition that the NVL-normalized HOLD_FLAG equals FL.LOOKUP_CODE, restricted to FL.LOOKUP_TYPE = 'YES_NO'. An additional filter, POV.ENABLED_FLAG = 'Y', ensures only active suppliers are returned. FND_GLOBAL is referenced to provide session-level context (such as the organization or user environment) during application execution. Although the underlying objects are exposed as views in the ETRM metadata, they map to the PO_VENDORS supplier foundation and the standard FND_LOOKUPS lookup repository.

Key Columns

• VENDOR_ID — Primary identifier for the supplier; used as the join key to downstream purchasing and receiving transactions.
• VENDOR_NAME / SEGMENT1 — Supplier name and the supplier number (segment) used for display and search.
• HOLD_STATUS — The decoded meaning of the hold indicator, derived from FND_LOOKUPS (YES_NO). This is the column most directly relevant to queries searching on "hold_status".
• HOLD_FLAG — The raw supplier hold flag (Y/N), retained for filtering.
• RECEIPT_REQUIRED_FLAG — Indicates whether goods receipts are required for the supplier.
• ALLOW_UNORDERED_RECEIPTS_FLAG — Controls whether receipts without a corresponding purchase order are permitted.
• TERMS_ID, SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID — Payment terms and default location references.
• SHIP_VIA_LOOKUP_CODE, FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE — Default shipping, FOB, and freight attributes.
• INVOICE_CURRENCY_CODE, VAT_CODE, VAT_REGISTRATION_NUM, NUM_1099, TYPE_1099 — Currency, tax, and reporting identifiers for the supplier.

Common Use Cases and Queries

The view supports supplier validation during receiving and purchasing, and it is a convenient source for reporting on supplier hold status without decoding lookups manually. A representative query retrieves active suppliers and their hold status:

SELECT vendor_id, vendor_name, segment1, hold_status, hold_flag
FROM   apps.rcv_suppliers_val_v
WHERE  hold_flag = 'Y';

To locate all currently held suppliers for review, filter on HOLD_STATUS or HOLD_FLAG directly. Because the view already joins FND_LOOKUPS, no separate lookup join is required to obtain a readable hold description. Note the ENABLED_FLAG = 'Y' restriction means inactive suppliers are excluded by design, so this view should not be used where disabled suppliers must also be reported.