APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_ITEM_SOURCING_LEVELS_V

Line 2069: FROM mrp_item_sourcing_levels_v mislv

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

Line 2101: FROM mrp_item_sourcing_levels_v mislv

2097: --
2098: --perf changes
2099: CURSOR c_MRP_item IS
2100: SELECT DISTINCT assignment_set_id
2101: FROM mrp_item_sourcing_levels_v mislv
2102: WHERE mislv.inventory_item_id = x_Group_rec.inventory_item_id
2103: AND mislv.organization_id = x_Group_rec.ship_from_org_id
2104: AND mislv.source_type IN (1,2)
2105: AND (SYSDATE BETWEEN mislv.effective_date

Line 2472: FROM mrp_item_sourcing_levels_v

2468: IF (v_source_level = 'ITEM') OR (v_source_level = 'PRFL' AND v_Index = 0) THEN --{
2469: --
2470: SELECT MIN(sourcing_level)
2471: INTO v_srcng_lvl
2472: FROM mrp_item_sourcing_levels_v
2473: WHERE organization_id = x_Group_rec.ship_from_org_id
2474: AND inventory_item_id = x_Group_rec.inventory_item_id
2475: AND assignment_set_id = v_assign_set_id;
2476: --

Line 2479: FROM mrp_item_sourcing_levels_v

2475: AND assignment_set_id = v_assign_set_id;
2476: --
2477: SELECT MIN(rank)
2478: INTO v_rank
2479: FROM mrp_item_sourcing_levels_v
2480: WHERE organization_id = x_Group_rec.ship_from_org_Id
2481: AND inventory_item_id = x_Group_rec.inventory_item_id
2482: AND (SYSDATE BETWEEN effective_date AND
2483: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397