APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 2095: FROM mrp_item_sourcing_levels_v mislv

2091: x_rank NUMBER) IS
2092: SELECT DECODE(mislv.source_type,2,mislv.organization_id,
2093: mislv.source_organization_id) org_id, mislv.allocation_percent, mislv.effective_date, --Bugfix 6051397
2094: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
2095: FROM mrp_item_sourcing_levels_v mislv
2096: WHERE mislv.assignment_set_id = x_assign_id
2097: AND mislv.sourcing_level = x_srcng_lvl
2098: AND mislv.inventory_item_id = x_inv_item_id
2099: AND mislv.organization_id = x_org_id

Line 2135: FROM mrp_item_sourcing_levels_v mislv

2131: --
2132: --perf changes
2133: CURSOR c_MRP_item IS
2134: SELECT DISTINCT assignment_set_id
2135: FROM mrp_item_sourcing_levels_v mislv
2136: WHERE mislv.inventory_item_id = x_Group_rec.inventory_item_id
2137: AND mislv.organization_id = x_Group_rec.ship_from_org_id
2138: AND mislv.source_type IN (1,2)
2139: --Bugfix 10053830 Start

Line 2522: FROM mrp_item_sourcing_levels_v

2518: IF (v_source_level = 'ITEM') OR (v_source_level = 'PRFL' AND v_Index = 0) THEN --{
2519: --
2520: SELECT MIN(sourcing_level)
2521: INTO v_srcng_lvl
2522: FROM mrp_item_sourcing_levels_v
2523: WHERE organization_id = x_Group_rec.ship_from_org_id
2524: AND inventory_item_id = x_Group_rec.inventory_item_id
2525: AND assignment_set_id = v_assign_set_id;
2526: --

Line 2529: FROM mrp_item_sourcing_levels_v

2525: AND assignment_set_id = v_assign_set_id;
2526: --
2527: SELECT MIN(rank)
2528: INTO v_rank
2529: FROM mrp_item_sourcing_levels_v
2530: WHERE organization_id = x_Group_rec.ship_from_org_Id
2531: AND inventory_item_id = x_Group_rec.inventory_item_id
2532: --Bugfix 10053830 Start
2533: /*AND (SYSDATE BETWEEN effective_date AND