APPS.OE_VALIDATE_LINE dependencies on MTL_SUBINVENTORIES_TRK_VAL_V

Line 4319: FROM MTL_SUBINVENTORIES_TRK_VAL_V

4315: p_line_rec.subinventory <> nvl(p_old_line_rec.subinventory, '0') THEN
4316: BEGIN
4317: SELECT 'VALID'
4318: INTO l_dummy
4319: FROM MTL_SUBINVENTORIES_TRK_VAL_V
4320: WHERE organization_id = p_line_rec.ship_from_org_id
4321: AND secondary_inventory_name = p_line_rec.subinventory;
4322: EXCEPTION
4323: WHEN OTHERS THEN

Line 4409: from mtl_subinventories_trk_val_v sub

4405: ELSE -- not a restricted subinv case
4406: BEGIN
4407: select 'Y'
4408: into l_dummy
4409: from mtl_subinventories_trk_val_v sub
4410: where sub.organization_id = p_line_rec.ship_from_org_id
4411: and sub.secondary_inventory_name = p_line_rec.subinventory
4412: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4413: OR