DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on MTL_ITEM_SUB_INVENTORIES

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

5451: --* We retrieve and apply order modifiers
5452: -- 1. if primary_uom of the item is same as the UOM mentioned on the requisition
5453: -- 2. if requisitions are generated from Inventory(Interface source code = 'INV')
5454:
5455: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.
5456:
5457: IF (l_primary_uom = x_unit_of_measure
5458: AND l_interface_source_code = 'INV')THEN
5459:

Line 5464: FROM MTL_ITEM_SUB_INVENTORIES mssi

5460: IF x_source_subinventory IS NOT NULL THEN
5461: BEGIN
5462: SELECT mssi.fixed_lot_multiple, mssi.minimum_order_quantity
5463: INTO l_fixed_lot_multiple, l_min_ord_qty
5464: FROM MTL_ITEM_SUB_INVENTORIES mssi
5465: WHERE mssi.secondary_inventory = x_source_subinventory
5466: AND mssi.inventory_item_id = x_item_id
5467: AND mssi.organization_id = x_source_organization_id;
5468: EXCEPTION