DBA Data[Home] [Help]

APPS.INV_VALIDATE_TROLIN dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1283: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item

1279: if( g_item.restrict_subinventories_code = 1 ) then
1280: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 1');
1281: BEGIN
1282: SELECT 'Y' INTO l_found
1283: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item
1284: WHERE item.inventory_item_id = p_trolin_rec.inventory_item_id
1285: AND sec.organization_id = p_trolin_Rec.organization_id
1286: AND sec.secondary_inventory_name = p_trolin_rec.to_subinventory_code
1287: AND sec.organization_id = item.organization_id