Search Results query_sourcing_org

Overview

CTO_UTILITY_PK is a core Configure-to-Order (CTO) utility package in Oracle E-Business Suite, shipped under the APPS schema and classified as an OTHER API. It provides the shared PL/SQL infrastructure that supports CTO order processing, configuration matching, sourcing determination, and supply creation within Oracle Manufacturing. The package body is defined in the source file CTOUTILB.pls, first created on 04-MAY-2000, and carries an extensive modification history reflecting more than a decade of defect fixes and enhancements through release 12.2.0. The package operates on temporary and staging tables, most notably bom_cto_order_lines and bom_cto_src_orgs, which serve as intermediate stores during CTO processing. Its documented responsibilities include populating those temporary tables, updating them with the configuration item identifier, and copying sourcing rule assignments from a model to its configured item. The package is referenced by 24 other packages, indicating it is a widely leveraged dependency across the CTO and ATP processing chain rather than a standalone entry point.

Key Procedures and Functions

The package exposes 38 documented procedures and functions. The following are central to its role:

• POPULATE_SRC_ORGS — populates the temporary sourcing organization table used during CTO processing.
• QUERY_SOURCING_ORG — the routine associated with the user's search; it queries and returns sourcing organization information for a given model or configuration context.
• GET_MODEL_SOURCING_ORG — retrieves the sourcing organization defined at the model level. This logic was relocated from CTO_ATP_INTERFACE_PK into this package on 15-JUN-2001 to eliminate the dependency on CTOATPIB.pls for change order processing.
• GET_ALL_ITEM_ORGS — returns the set of organizations associated with an item.
• UPDATE_ORDER_LINES and UPDATE_SRC_ORGS — update the temporary staging tables with configuration identifiers and sourcing details.
• CREATE_SOURCING_RULES — creates sourcing rule assignments copied from the model to the config item.
• POPULATE_BCOL — populates the bom_cto_order_lines staging table.
• CONVERT_UOM — performs weight and volume unit-of-measure conversions; added as bugfix 1811007.
• GET_SOURCE_DOCUMENT_ID — resolves the source document identifier for CTO sourcing.
• CHECK_RSV_QUANTITY, CHK_ALL_RSV_DETAILS, and CHECK_CONFIG_ITEM — validation routines for reservations and configuration items.
• CREATE_ATTACHMENT, GENERATE_BOM_ATTACH_TEXT, and CONCAT_VALUES — generate and attach textual BOM documentation.
• ISMODELMLMO, CREATE_ISP_BOM, COPY_COST, and CHECK_CTO_CAN_CREATE_SUPPLY — support model classification, inter-org supply planning, cost copying, and supply eligibility checks.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. Temporary processing relies on BOM_CTO_ORDER_LINES, BOM_CTO_ORDER_LINES_GT, and BOM_EXPLOSION_TEMP along with its sequence counterpart BOM_EXPLOSION_TEMP_S. Configuration and routing logic reference MTL_SYSTEM_ITEMS, BOM_OPERATIONAL_ROUTINGS, and FINANCIALS_SYSTEM_PARAMS_ALL. Cost-related procedures access CST_ITEM_COSTS and CST_ITEM_COST_DETAILS. Attachment generation uses FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENTS_TL, FND_LANGUAGES, and FND_USER for authorship and language context.

Usage Notes

CTO_UTILITY_PK is not typically invoked directly by end users. It is called programmatically by CTO order-processing flows, change order packages, and concurrent programs that transform a configured model into concrete configured items with sourcing rules, attachments, and costs. Custom extensions that must replicate CTO sourcing behavior should call QUERY_SOURCING_ORG or GET_MODEL_SOURCING_ORG rather than reimplementing the logic, ensuring consistency with the Oracle-maintained rules.