DBA Data[Home] [Help]

APPS.INV_ITEM_SUB_DEFAULT_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 83: FROM mtl_secondary_inventories

79:
80: IF p_subinventory_code IS NOT NULL THEN
81: BEGIN
82: SELECT 'X' INTO l_subinv_code
83: FROM mtl_secondary_inventories
84: WHERE secondary_inventory_name = p_subinventory_code
85: AND nvl(disable_date,sysdate+1) > sysdate
86: AND organization_id = p_organization_id;
87: EXCEPTION