DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on MTL_ITEM_SUB_INVENTORIES

Line 5378: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.

5374: --* We retrieve and apply order modifiers
5375: -- 1. if primary_uom of the item is same as the UOM mentioned on the requisition
5376: -- 2. if requisitions are generated from Inventory(Interface source code = 'INV')
5377:
5378: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.
5379:
5380: IF (l_primary_uom = x_unit_of_measure
5381: AND l_interface_source_code = 'INV')THEN
5382:

Line 5387: FROM MTL_ITEM_SUB_INVENTORIES mssi

5383: IF x_source_subinventory IS NOT NULL THEN
5384: BEGIN
5385: SELECT mssi.fixed_lot_multiple, mssi.minimum_order_quantity
5386: INTO l_fixed_lot_multiple, l_min_ord_qty
5387: FROM MTL_ITEM_SUB_INVENTORIES mssi
5388: WHERE mssi.secondary_inventory = x_source_subinventory
5389: AND mssi.inventory_item_id = x_item_id
5390: AND mssi.organization_id = x_source_organization_id;
5391: EXCEPTION