APPS.OE_VALIDATE_LINE dependencies on MTL_SUBINVENTORIES_TRK_VAL_V

Line 4019: FROM MTL_SUBINVENTORIES_TRK_VAL_V

4015: p_line_rec.subinventory <> nvl(p_old_line_rec.subinventory, '0') THEN
4016: BEGIN
4017: SELECT 'VALID'
4018: INTO l_dummy
4019: FROM MTL_SUBINVENTORIES_TRK_VAL_V
4020: WHERE organization_id = p_line_rec.ship_from_org_id
4021: AND secondary_inventory_name = p_line_rec.subinventory;
4022: EXCEPTION
4023: WHEN OTHERS THEN

Line 4109: from mtl_subinventories_trk_val_v sub

4105: ELSE -- not a restricted subinv case
4106: BEGIN
4107: select 'Y'
4108: into l_dummy
4109: from mtl_subinventories_trk_val_v sub
4110: where sub.organization_id = p_line_rec.ship_from_org_id
4111: and sub.secondary_inventory_name = p_line_rec.subinventory
4112: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4113: OR