Results for “primary_unit_of_measure”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PO_REQ_TEMPLATE_SV2 is a server-side PL/SQL package body in the Oracle E-Business Suite Purchasing module. It supplies the core validation and data-retrieval logic used by the Requisition Templates (ReqExpress) feature, which allows buyers and requesters to build reusable requisition templates that pre-populate line, item, sourcing, and pricing information on new requisitions. The package operates as an "OTHER"-classified API, meaning it is not a formal public interface but an internal service layer invoked by the Requisition Templates forms and supporting logic.
The body carries header revision information dating to 2003, indicating it is a long-standing component that has been carried forward unchanged into the 12.1.1 and 12.2.2 releases. Its procedures combine two responsibilities: populating descriptive and sourcing attributes for a template line, and enforcing uniqueness constraints on template-defining name and sequence attributes. The user search term "duplicate_sequence_number" corresponds directly to one of the package's documented procedures, which is used to detect conflicting line sequence numbering within a template.
Key Procedures and Functions
- GET_REQ_LINE_INFO — The principal data-retrieval routine. It returns item, revision, description, category, unit of measure, unit price, vendor, vendor site and contact, suggested buyer, source type and source organization, line type, RFQ flag, and amount information for a requisition template line, based on a row identifier and inventory organization. It also derives display values such as vendor name, vendor site, source organization name, and suggested buyer name.
- DUPLICATE_SEQUENCE_NUMBER — Validates whether a proposed line sequence number already exists within a Requisition Template (ReqExpress) header, preventing duplicate line ordering from being saved.
- DUPLICATE_EXPRESS_NAME — Checks whether a Requisition Template name already exists, enforcing unique template names.
- INVENTORY_ITEM_COST — Retrieves the cost associated with an inventory item, used to default or validate pricing on template lines.
- PRIMARY_UNIT_OF_MEASURE — Returns the primary unit of measure for an item, supporting defaulting of the UOM attribute.
- GET_ORDER_TYPE — Returns the applicable order type lookup value, used to determine the purchasing document type associated with a template line.
Tables Accessed
- PO_REQEXPRESS_HEADERS and PO_REQEXPRESS_LINES — The core Requisition Template (ReqExpress) header and line tables. These support duplicate name and sequence validation and provide the line rows read by GET_REQ_LINE_INFO.
- PO_REQUISITION_LINES — The requisition line table, supplying line-level descriptive and sourcing attributes.
- MTL_SYSTEM_ITEMS — Item master information, used to resolve item attributes and primary unit of measure.
- PO_LINE_TYPES — Line type definitions, used to validate or retrieve the line type associated with template lines.
- DUAL — Used for single-row computations and defaulting logic.
Usage Notes
PO_REQ_TEMPLATE_SV2 is typically invoked from the Requisition Templates (ReqExpress) forms while a user creates or edits a template. When a line is entered or queried, the form calls GET_REQ_LINE_INFO to populate dependent fields, and calls DUPLICATE_SEQUENCE_NUMBER and DUPLICATE_EXPRESS_NAME during validation to enforce uniqueness before saving. INVENTORY_ITEM_COST, PRIMARY_UNIT_OF_MEASURE, and GET_ORDER_TYPE support item defaulting and pricing behavior.
Because the package is classified as OTHER and is referenced by no other packages, it is not intended as a public integration API. Customizations should avoid calling it directly and should instead rely on supported requisition or template APIs, since internal signatures may change across patches. In 12.1.1 and 12.2.2 deployments the package remains form-driven, with no concurrent program interface documented.
-
View giving unit of measure conversion rates between the primary unit of measure and another unit of measure
APPS.MTL_UOM_CONVERSIONS_VIEW·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_UNITS_OF_MEASURE_VL·↳ MTL_UOM_CLASS_CONVERSIONS·Explore INV module →
-
APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
Item Availability by Organization View
APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ICX module →
-
View giving unit of measure conversion rates between the primary unit of measure and another unit of measure
APPS.MTL_UOM_CONVERSIONS_VIEW·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_UNITS_OF_MEASURE_VL·↳ MTL_UOM_CLASS_CONVERSIONS·Explore INV module →
-
Item Availability View
APPS.ICX_MTL_DEMAND_ITEM_SUM_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ ICX_MTL_DEMAND_SUMMARY_V·Explore ICX module →
-
View: MTL_SYSTEM_ITEMS_ER4_V 12.1.1
ERES : View to support ERES framework for Items Organization Assignment
APPS.MTL_SYSTEM_ITEMS_ER4_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ INV_MEANING_SEL·↳ MTL_PARAMETERS·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_ER4_V 12.2.2
ERES : View to support ERES framework for Items Organization Assignment
APPS.MTL_SYSTEM_ITEMS_ER4_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ INV_MEANING_SEL·↳ MTL_PARAMETERS·Explore INV module →
-
View: CST_XLA_RCV_V 12.2.2
APPS.CST_XLA_RCV_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_KFV·↳ PO_DISTRIBUTIONS_ALL·Explore BOM module →
-
View: CST_XLA_RCV_V 12.1.1
APPS.CST_XLA_RCV_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_KFV·↳ PO_DISTRIBUTIONS_ALL·Explore BOM module →
-
APPS.AST_ITEM_RELATIONSHIPS_V·↳ FND_PROFILE·↳ MFG_LOOKUPS·↳ MTL_ITEM_QUANTITIES_VIEW·Explore AST module →
-
Item Availability by Organization View
APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ICX module →
-
APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
Item Availability View
APPS.ICX_MTL_DEMAND_ITEM_SUM_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ ICX_MTL_DEMAND_SUMMARY_V·Explore ICX module →
-
View: MTL_ORG_ASSIGN_V 12.2.2
10SC ONLY
APPS.MTL_ORG_ASSIGN_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
APPS.AST_EVENT_DELIVERABLES_V·↳ AMS_DELIVERABLES_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_OBJECT_ASSOCIATIONS·Explore AST module →
-
APPS.CHV_RECEIVING_TRANSACTIONS_V·↳ CHV_CUM_ADJUSTMENTS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore CHV module →
-
APPS.AST_EVENT_DELIVERABLES_V·↳ AMS_DELIVERABLES_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_OBJECT_ASSOCIATIONS·Explore AST module →
-
View: OE_OPTION_ITEMS_V 12.1.1
View for Option Items LOV
APPS.OE_OPTION_ITEMS_V·↳ BOM_EXPLOSIONS·↳ MTL_ITEM_FLEXFIELDS·Explore ONT module →
-
APPS.CHV_RECEIVING_TRANSACTIONS_V·↳ CHV_CUM_ADJUSTMENTS·↳ FND_GLOBAL·↳ FND_PROFILE·Explore CHV module →
-
APPS.AST_ITEM_RELATIONSHIPS_V·↳ FND_PROFILE·↳ MFG_LOOKUPS·↳ MTL_ITEM_QUANTITIES_VIEW·Explore AST module →
-
View: OE_OPTION_ITEMS_V 12.2.2
View for Option Items LOV
APPS.OE_OPTION_ITEMS_V·↳ BOM_EXPLOSIONS·↳ MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_TL·Explore ONT module →
-
APPS.JAI_RCV_RECEIVE_LINES_V·↳ JAI_RCV_LINES·↳ RCV_SHIPMENT_HEADERS·↳ RCV_SHIPMENT_LINES·Explore JA module →
-
View: MTL_ORG_ASSIGN_V 12.1.1
10SC ONLY
APPS.MTL_ORG_ASSIGN_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
View: ASO_I_ITEMS_V 12.1.1
This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column
APPS.ASO_I_ITEMS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
APPS.POS_CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore PO module →
-
View: CHV_AUTHORIZATIONS_V 12.2.2
- Retrofitted
APPS.CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore CHV module →
-
CUM adjustments table
-
CUM adjustments table
-
View: CSD_BOM_INQUIRY_EXPL_V 12.2.2
View based on temporary table.
APPS.CSD_BOM_INQUIRY_EXPL_V·↳ BOM_BILL_OF_MATERIALS·↳ CSD_BOM_EXPL_TEMP·↳ FND_GLOBAL·Explore CSD module →
-
View: AST_LM_COLLATERAL_V 12.1.1
APPS.AST_LM_COLLATERAL_V·↳ AMS_DELIVERABLES_VL·↳ AMS_P_SOURCE_CODES_V·↳ AMS_USER_STATUSES_VL·Explore AST module →
-
Setup table to hold the quality threshold setups.
-
View: ASO_I_ITEMS_V 12.2.2
This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column
APPS.ASO_I_ITEMS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
View: ICX_CHV_ITEM_ORDERS_V 12.1.1
APPS.ICX_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore ICX module →
-
Authorizations table
-
View: POS_CHV_ITEM_ORDERS_V 12.2.2
used to select the item orders details info
APPS.POS_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore POS module →
-
View: POS_CHV_ITEM_ORDERS_V 12.2.2
APPS.POS_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore PO module →
-
View: ICX_CHV_ITEM_ORDERS_V 12.2.2
APPS.ICX_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore ICX module →
-
View: CSD_BOM_INQUIRY_EXPL_V 12.1.1
View based on temporary table.
APPS.CSD_BOM_INQUIRY_EXPL_V·↳ BOM_BILL_OF_MATERIALS·↳ CSD_BOM_EXPL_TEMP·↳ CS_STD·Explore CSD module →
-
View: POS_SHIPMENTS_V 12.2.2
Create ASN View
APPS.POS_SHIPMENTS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
Item orders table
-
View: CHV_AUTHORIZATIONS_V 12.1.1
- Retrofitted
APPS.CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore CHV module →
-
APPS.SO_ITEM_GROUP_LINES_ALL_V·↳ FND_PROFILE·↳ MTL_SYSTEM_ITEMS_KFV·↳ SO_ITEM_GROUP_LINES·Explore OE module →
-
Item orders table
-
Configurator Components View
APPS.ICX_CONFIG_COMPONENTS_WEB_V·↳ BOM_CONFIG_EXPLOSIONS·↳ MTL_SYSTEM_ITEMS_KFV·Explore ICX module →