APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_SCATP_ITEM_SR_LEVELS_V

Line 1974: FROM msc_scatp_item_sr_levels_v mislv

1970: x_ship_to_site_id NUMBER) IS
1971: SELECT DECODE(mislv.source_type,2,mislv.source_organization_id,
1972: mislv.source_organization_id) org_id, mislv.allocation_percent ,mislv.effective_date, --Bugfix 6051397
1973: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
1974: FROM msc_scatp_item_sr_levels_v mislv
1975: WHERE mislv.assignment_set_id = x_assign_id
1976: AND mislv.sourcing_level = x_srcng_lvl
1977: AND mislv.inventory_item_id = x_inv_item_id
1978: AND mislv.source_type IN (1,2)

Line 2023: FROM msc_scatp_item_sr_levels_v mislv

2019: ORDER BY mislv.allocation_percent;
2020: --
2021: CURSOR c_MSC_site IS
2022: select DISTINCT assignment_set_id
2023: FROM msc_scatp_item_sr_levels_v mislv
2024: WHERE mislv.inventory_item_id = sr_item_id
2025: AND mislv.source_type IN (1,2)
2026: --Bugfix 10053830 Start
2027: /* AND (SYSDATE BETWEEN mislv.effective_date

Line 2404: FROM msc_scatp_item_sr_levels_v

2400: IF (v_source_level = 'PRFL') OR (v_source_level = 'SITE') THEN --{
2401: --
2402: SELECT MIN(sourcing_level)
2403: INTO v_srcng_lvl
2404: FROM msc_scatp_item_sr_levels_v
2405: WHERE inventory_item_id = sr_item_id
2406: AND assignment_set_id = v_assign_set_id
2407: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2408: --

Line 2411: FROM msc_scatp_item_sr_levels_v

2407: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id;
2408: --
2409: SELECT MIN(rank)
2410: INTO v_rank
2411: FROM msc_scatp_item_sr_levels_v
2412: WHERE inventory_item_id = sr_item_id
2413: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2414: --Bugfix 10053830 Start
2415: /*AND (SYSDATE BETWEEN effective_date AND