Search Results is_internal_orderable




Overview
Explore in AI Chat

Overview

POR_AUTOSOURCE_UTIL_PKG is an Oracle EBS Order Management and Inventory utility package owned by the APPS schema and classified as an OTHER API. Its central purpose is to resolve sourcing decisions for order lines and internal requisitions: determining whether an item can be sourced from another inventory organization, whether it is purchasable or shippable, and, through the AUTOSOURCE function, returning the specific source organization, subinventory, sourcing type, and cost or price information that Order Management must use to fulfill demand. The package header declares AUTHID CURRENT_USER and dates from Release 11i ($Header: PORSRCUS.pls 115.6 2003/02/21 $), and it remains present and documented in both EBS 12.1.1 and 12.2.2. The user search term is_internal_orderable corresponds directly to the IS_INTERNAL_ORDERABLE function, the entry point that validates whether an item may be internally ordered (that is, sourced through an internal requisition or internal sales order flow) out of a given organization. In the sourcing model, this package supports the logic behind the Order Management shipment and sourcing forms, helping the application default and validate source warehouses without user intervention.

Key Procedures and Functions

The ETRM metadata documents six public functions, all of which return values used by the sourcing engine:

  • IS_INTERNAL_ORDERABLE — Returns a numeric indicator of whether the specified item can be internally ordered from a given organization. This is the function referenced by the search term and is the primary gate for internal requisition and internal sales order sourcing.
  • IS_ITEM_PURCHASABLE — Indicates whether the item is purchasable in the specified organization, which governs whether buy-side sourcing (purchasing or internal requisition) is permitted.
  • IS_ITEM_SHIPPABLE — Indicates whether the item is shippable from the specified organization, controlling whether the item may be transferred or sold through shipping networks.
  • IS_VALID_SHIPPING_NETWORK — Validates that a shipping network exists between a from-organization and a to-organization, ensuring inter-organization transfers are defined and legal.
  • IS_ITEM_ASSIGNED — Confirms that the item is assigned to the source organization, a prerequisite for any downstream sourcing decision.
  • AUTOSOURCE — The main engine. Given an item, category, destination organization and subinventory, and optional vendor and vendor site, it returns the unit of issue, source organization, source subinventory, sourcing type, cost or price, and an error message code, or a Boolean success indicator.

Tables Accessed

Through APPS synonyms the package references MTL_SYSTEM_ITEMS (item definition attributes), MTL_ITEM_SUB_INVENTORIES (item-to-subinventory assignment), MTL_SECONDARY_INVENTORIES (subinventory setup), MTL_INTERORG_PARAMETERS (inter-organization sourcing and shipping relationships), and MTL_RESERVATIONS (reservation activity relevant to availability and sourcing). These tables supply the item master attributes, subinventory configuration, and inter-org parameters needed to compute a valid source.

Usage Notes

POR_AUTOSOURCE_UTIL_PKG is typically invoked implicitly by Order Management sourcing forms, the internal requisition flow, and the AutoSource concurrent processing path. Because the metadata reports it as referenced by zero other packages, it is an entry-point utility rather than a shared library; customizations should call it from forms personalizations, custom PL/SQL, or concurrent programs using the documented signatures. Developers should treat it as an API to be called rather than modified, and should call IS_INTERNAL_ORDERABLE separately when only an internal-orderability check is required, reserving AUTOSOURCE for full source resolution.