Results for “on_hold”

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

Overview

RCV_SOURCES_BOTH_VAL_V is a VALID Oracle E-Business Suite view owned by the APPS schema and registered under the PO — Purchasing product family. Its internal description, "10SC ONLY - Retrofitted," indicates that the object originated in a 10SC (release 10 Smart Client) environment and was retrofitted into later EBS releases, including 12.1.1 and 12.2.2. The view presents a unified, validated list of sourcing parties — both suppliers (vendors) and internal inventory organizations — that are eligible for selection in receiving and sourcing-related transactions.

Functionally, RCV_SOURCES_BOTH_VAL_V consolidates two distinct source populations into a single result set. The first population consists of validated suppliers drawn from RCV_SUPPLIERS_VAL_V, exposed with a SOURCE_TYPE of 'VENDOR'. The second population consists of internal organizations drawn from ORG_ORGANIZATION_DEFINITIONS, exposed with a SOURCE_TYPE of 'ORGANIZATION'. Because both types are returned through an identical column footprint, the view supports LOV (List of Values) populations, receiving form logic, and integration queries that must treat external suppliers and internal organizations interchangeably.

Underlying Base Objects

The documented base objects referenced by this view in ETRM 12.2.2 are:

• RCV_SUPPLIERS_VAL_V (VIEW) — supplies the vendor row set.
• ORG_ORGANIZATION_DEFINITIONS (VIEW) — supplies the internal organization row set.
• FND_GLOBAL (PACKAGE) — provides session context such as ORG_ID and USER_ID.
• HR_GENERAL (PACKAGE) — resolves organization and business group context.
• HR_SECURITY (PACKAGE) — enforces organization-level security filtering.

The view text is a UNION of two queries. The vendor branch selects VENDOR_ID, VENDOR_NAME, SEGMENT1, the literal 'VENDOR', HOLD_STATUS, NUM_1099, and VAT_REGISTRATION_NUM from RCV_SUPPLIERS_VAL_V. The organization branch selects ORGANIZATION_ID, ORGANIZATION_NAME, ORGANIZATION_CODE, the literal 'ORGANIZATION', and NULLs for the hold, 1099, and tax-registration positions from ORG_ORGANIZATION_DEFINITIONS. The NULL padding in the second branch preserves column alignment across the UNION.

Key Columns

• SOURCE_ID — the identifier of the source; maps to VENDOR_ID for vendors and ORGANIZATION_ID for organizations.
• SOURCE_NAME — the descriptive name; VENDOR_NAME or ORGANIZATION_NAME.
• SOURCE_CODE — the short code; SEGMENT1 (vendor number) or ORGANIZATION_CODE.
• SOURCE_TYPE — discriminator, either 'VENDOR' or 'ORGANIZATION'.
• ON_HOLD — vendor hold status; NULL for organizations.
• TAXPAYER_ID — populated from NUM_1099 in the underlying supplier view; NULL for organizations. This column is the field of interest referenced by searches for "num_1099."
• TAX_REGISTRATION_NUM — vendor VAT registration number; NULL for organizations.

Common Use Cases and Queries

Typical scenarios include populating a combined source LOV in receiving forms, filtering only supplier sources for 1099-related reporting, and listing internal organizations available as receiving destinations.

SELECT SOURCE_ID, SOURCE_NAME, SOURCE_CODE, SOURCE_TYPE,
       ON_HOLD, TAXPAYER_ID, TAX_REGISTRATION_NUM
  FROM APPS.RCV_SOURCES_BOTH_VAL_V
 WHERE SOURCE_TYPE = 'VENDOR'
   AND TAXPAYER_ID IS NOT NULL;

SELECT SOURCE_ID, SOURCE_NAME
  FROM APPS.RCV_SOURCES_BOTH_VAL_V
 WHERE SOURCE_TYPE = 'ORGANIZATION'
 ORDER BY SOURCE_NAME;

Because TAXPAYER_ID is populated only from NUM_1099 on the vendor branch, queries filtering or exporting 1099 tax identification numbers should constrain SOURCE_TYPE = 'VENDOR'. For the combined source list used in receiving LOVs, omit that filter to return both vendors and organizations.