APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_ITEM_SOURCING_LEVELS_V

Line 2045: FROM msc_item_sourcing_levels_v mislv

2041: x_rank NUMBER) IS
2042: SELECT DECODE(mislv.source_type,2,mislv.organization_id,
2043: mislv.source_organization_id) org_id, mislv.allocation_percent, mislv.effective_date, --Bugfix 6051397
2044: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) --Bugfix 6051397
2045: FROM msc_item_sourcing_levels_v mislv
2046: WHERE mislv.assignment_set_id = x_assign_id
2047: AND mislv.sourcing_level = x_srcng_lvl
2048: AND mislv.inventory_item_id = x_inv_item_id
2049: AND mislv.organization_id = x_org_id

Line 2087: FROM msc_item_sourcing_levels_v mislv

2083: --
2084: --perf changes
2085: CURSOR c_MSC_item IS
2086: select DISTINCT assignment_set_id
2087: FROM msc_item_sourcing_levels_v mislv
2088: WHERE mislv.inventory_item_id = sr_item_id
2089: AND mislv.organization_id = x_Group_rec.ship_from_org_id
2090: AND mislv.source_type IN (1,2)
2091: AND (SYSDATE BETWEEN mislv.effective_date

Line 2401: FROM msc_item_sourcing_levels_v

2397: IF (v_source_level = 'ITEM') OR (v_source_level = 'PRFL' AND v_Index = 0) THEN --{
2398: --
2399: SELECT MIN(sourcing_level)
2400: INTO v_srcng_lvl
2401: FROM msc_item_sourcing_levels_v
2402: WHERE organization_id = x_Group_rec.ship_from_org_id
2403: AND inventory_item_id = sr_item_id
2404: AND assignment_set_id = v_assign_set_id;
2405: --

Line 2408: FROM msc_item_sourcing_levels_v

2404: AND assignment_set_id = v_assign_set_id;
2405: --
2406: SELECT MIN(rank)
2407: INTO v_rank
2408: FROM msc_item_sourcing_levels_v
2409: WHERE organization_id = x_Group_rec.ship_from_org_Id
2410: AND inventory_item_id = sr_item_id
2411: AND (SYSDATE BETWEEN effective_date AND
2412: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397