APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_SCATP_ITEM_SR_LEVELS_V

Line 2002: FROM mrp_scatp_item_sr_levels_v mislv

1998: x_ship_to_site_id NUMBER) IS
1999: SELECT DECODE(mislv.source_type,2,mislv.source_organization_id,
2000: mislv.source_organization_id) org_id, mislv.allocation_percent ,mislv.effective_date, --Bugfix 6051397
2001: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
2002: FROM mrp_scatp_item_sr_levels_v mislv
2003: WHERE mislv.assignment_set_id = x_assign_id
2004: AND mislv.sourcing_level = x_srcng_lvl
2005: AND mislv.inventory_item_id = x_inv_item_id
2006: AND mislv.source_type IN (1,2)

Line 2040: FROM mrp_scatp_item_sr_levels_v mislv

2036: AND planning_active = k_PLANNING_ACTIVE);
2037: --
2038: CURSOR c_MRP_site IS
2039: SELECT DISTINCT assignment_set_id
2040: FROM mrp_scatp_item_sr_levels_v mislv
2041: WHERE mislv.inventory_item_id = x_Group_rec.inventory_item_id
2042: AND mislv.source_type IN (1,2)
2043: --Bugfix 10053830 Start
2044: /*AND (SYSDATE BETWEEN mislv.effective_date

Line 2482: FROM mrp_scatp_item_sr_levels_v

2478: -- Determine the minimum sourcing level and rank
2479: --
2480: SELECT MIN(sourcing_level)
2481: INTO v_srcng_lvl
2482: FROM mrp_scatp_item_sr_levels_v
2483: WHERE inventory_item_id = x_Group_rec.inventory_item_id
2484: AND assignment_set_id = v_assign_set_id
2485: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2486: --

Line 2489: FROM mrp_scatp_item_sr_levels_v

2485: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2486: --
2487: SELECT MIN(rank)
2488: INTO v_rank
2489: FROM mrp_scatp_item_sr_levels_v
2490: WHERE inventory_item_id = x_Group_rec.inventory_item_id
2491: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2492: --Bugfix 10053830 Start
2493: /*AND (SYSDATE BETWEEN effective_date AND