APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_SCATP_ITEM_SR_LEVELS_V

Line 1968: FROM msc_scatp_item_sr_levels_v mislv

1964: x_ship_to_site_id NUMBER) IS
1965: SELECT DECODE(mislv.source_type,2,mislv.source_organization_id,
1966: mislv.source_organization_id) org_id, mislv.allocation_percent ,mislv.effective_date, --Bugfix 6051397
1967: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
1968: FROM msc_scatp_item_sr_levels_v mislv
1969: WHERE mislv.assignment_set_id = x_assign_id
1970: AND mislv.sourcing_level = x_srcng_lvl
1971: AND mislv.inventory_item_id = x_inv_item_id
1972: AND mislv.source_type IN (1,2)

Line 2009: FROM msc_scatp_item_sr_levels_v mislv

2005: ORDER BY mislv.allocation_percent;
2006: --
2007: CURSOR c_MSC_site IS
2008: select DISTINCT assignment_set_id
2009: FROM msc_scatp_item_sr_levels_v mislv
2010: WHERE mislv.inventory_item_id = sr_item_id
2011: AND mislv.source_type IN (1,2)
2012: AND (SYSDATE BETWEEN mislv.effective_date
2013: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397

Line 2366: FROM msc_scatp_item_sr_levels_v

2362: IF (v_source_level = 'PRFL') OR (v_source_level = 'SITE') THEN --{
2363: --
2364: SELECT MIN(sourcing_level)
2365: INTO v_srcng_lvl
2366: FROM msc_scatp_item_sr_levels_v
2367: WHERE inventory_item_id = sr_item_id
2368: AND assignment_set_id = v_assign_set_id
2369: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2370: --

Line 2373: FROM msc_scatp_item_sr_levels_v

2369: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2370: --
2371: SELECT MIN(rank)
2372: INTO v_rank
2373: FROM msc_scatp_item_sr_levels_v
2374: WHERE inventory_item_id = sr_item_id
2375: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2376: AND (SYSDATE BETWEEN effective_date AND
2377: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397