APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_SCATP_ITEM_SR_LEVELS_V

Line 1992: FROM mrp_scatp_item_sr_levels_v mislv

1988: x_ship_to_site_id NUMBER) IS
1989: SELECT DECODE(mislv.source_type,2,mislv.source_organization_id,
1990: mislv.source_organization_id) org_id, mislv.allocation_percent ,mislv.effective_date, --Bugfix 6051397
1991: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
1992: FROM mrp_scatp_item_sr_levels_v mislv
1993: WHERE mislv.assignment_set_id = x_assign_id
1994: AND mislv.sourcing_level = x_srcng_lvl
1995: AND mislv.inventory_item_id = x_inv_item_id
1996: AND mislv.source_type IN (1,2)

Line 2022: FROM mrp_scatp_item_sr_levels_v mislv

2018: AND planning_active = k_PLANNING_ACTIVE);
2019: --
2020: CURSOR c_MRP_site IS
2021: SELECT DISTINCT assignment_set_id
2022: FROM mrp_scatp_item_sr_levels_v mislv
2023: WHERE mislv.inventory_item_id = x_Group_rec.inventory_item_id
2024: AND mislv.source_type IN (1,2)
2025: AND (SYSDATE BETWEEN mislv.effective_date
2026: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397

Line 2436: FROM mrp_scatp_item_sr_levels_v

2432: -- Determine the minimum sourcing level and rank
2433: --
2434: SELECT MIN(sourcing_level)
2435: INTO v_srcng_lvl
2436: FROM mrp_scatp_item_sr_levels_v
2437: WHERE inventory_item_id = x_Group_rec.inventory_item_id
2438: AND assignment_set_id = v_assign_set_id
2439: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2440: --

Line 2443: FROM mrp_scatp_item_sr_levels_v

2439: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2440: --
2441: SELECT MIN(rank)
2442: INTO v_rank
2443: FROM mrp_scatp_item_sr_levels_v
2444: WHERE inventory_item_id = x_Group_rec.inventory_item_id
2445: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2446: AND (SYSDATE BETWEEN effective_date AND
2447: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397