DBA Data[Home] [Help]

APPS.INV_VALIDATE_TROLIN dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1269: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item

1265: if( g_item.restrict_subinventories_code = 1 ) then
1266: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 1');
1267: BEGIN
1268: SELECT 'Y' INTO l_found
1269: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item
1270: WHERE item.inventory_item_id = p_trolin_rec.inventory_item_id
1271: AND sec.organization_id = p_trolin_Rec.organization_id
1272: AND sec.secondary_inventory_name = p_trolin_rec.to_subinventory_code
1273: AND sec.organization_id = item.organization_id