APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_ITEM_SOURCING_LEVELS_V

Line 2067: FROM msc_item_sourcing_levels_v mislv

2063: x_rank NUMBER) IS
2064: SELECT DECODE(mislv.source_type,2,mislv.organization_id,
2065: mislv.source_organization_id) org_id, mislv.allocation_percent, mislv.effective_date, --Bugfix 6051397
2066: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
2067: FROM msc_item_sourcing_levels_v mislv
2068: WHERE mislv.assignment_set_id = x_assign_id
2069: AND mislv.sourcing_level = x_srcng_lvl
2070: AND mislv.inventory_item_id = x_inv_item_id
2071: AND mislv.organization_id = x_org_id

Line 2117: FROM msc_item_sourcing_levels_v mislv

2113: --
2114: --perf changes
2115: CURSOR c_MSC_item IS
2116: select DISTINCT assignment_set_id
2117: FROM msc_item_sourcing_levels_v mislv
2118: WHERE mislv.inventory_item_id = sr_item_id
2119: AND mislv.organization_id = x_Group_rec.ship_from_org_id
2120: AND mislv.source_type IN (1,2)
2121: --Bugfix 10053830 Start

Line 2443: FROM msc_item_sourcing_levels_v

2439: IF (v_source_level = 'ITEM') OR (v_source_level = 'PRFL' AND v_Index = 0) THEN --{
2440: --
2441: SELECT MIN(sourcing_level)
2442: INTO v_srcng_lvl
2443: FROM msc_item_sourcing_levels_v
2444: WHERE organization_id = x_Group_rec.ship_from_org_id
2445: AND inventory_item_id = sr_item_id
2446: AND assignment_set_id = v_assign_set_id;
2447: --

Line 2450: FROM msc_item_sourcing_levels_v

2446: AND assignment_set_id = v_assign_set_id;
2447: --
2448: SELECT MIN(rank)
2449: INTO v_rank
2450: FROM msc_item_sourcing_levels_v
2451: WHERE organization_id = x_Group_rec.ship_from_org_Id
2452: AND inventory_item_id = sr_item_id
2453: --Bugfix 10053830 Start
2454: /*AND (SYSDATE BETWEEN effective_date AND