APPS.MSC_ATP_FUNC dependencies on MSC_SYSTEM_ITEMS

Line 34: FROM msc_system_items

30: -- No for the bom.
31: /*
32: SELECT atp_flag
33: INTO l_atp_flag
34: FROM msc_system_items
35: WHERE sr_inventory_item_id = p_inventory_item_id
36: AND organization_id = p_organization_id
37: AND plan_id = p_plan_id
38: AND sr_instance_id = p_instance_id;

Line 43: FROM msc_system_items i, msc_bom_temp b

39: */
40:
41: SELECT i.atp_flag, i.bom_item_type, b.atp_check
42: INTO l_atp_flag, l_bom_item_type, l_atp_check
43: FROM msc_system_items i, msc_bom_temp b
44: WHERE i.sr_inventory_item_id = p_inventory_item_id
45: AND i.organization_id = p_organization_id
46: AND i.plan_id = p_plan_id
47: AND i.sr_instance_id = p_instance_id

Line 107: FROM msc_system_items

103: SELECT atp_components_flag , bom_item_type,
104: pick_components_flag, replenish_to_order_flag
105: INTO l_atp_comp_flag, l_bom_item_type,
106: l_pick_comp_flag, l_replenish_flag
107: FROM msc_system_items
108: WHERE sr_inventory_item_id = p_inventory_item_id
109: AND organization_id = p_organization_id
110: AND plan_id = -1
111: AND sr_instance_id = p_instance_id;

Line 310: FROM msc_system_items i

306: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting item type for PDS');
307: END IF;
308: SELECT i.bom_item_type
309: INTO l_item_type
310: FROM msc_system_items i
311: WHERE i.plan_id = p_plan_id
312: AND i.sr_instance_id = p_instance_id
313: AND i.organization_id = p_organization_id
314: AND i.sr_inventory_item_id = p_inventory_item_id;

Line 338: msc_system_items i

334: FROM msc_calendar_dates c2,
335: msc_calendar_dates c1,
336: msc_atp_rules r,
337: msc_trading_partners tp,
338: msc_system_items i
339: WHERE i.sr_inventory_item_id = p_inventory_item_id
340: AND i.organization_id = p_organization_id
341: --AND i.plan_id = p_plan_id
342: AND i.plan_id = -1 -- for 1478110

Line 444: FROM msc_system_items

440: BEGIN
441:
442: SELECT substr(ITEM_NAME, 1, 40)
443: INTO l_inv_item_name
444: FROM msc_system_items
445: WHERE organization_id = p_organization_id
446: AND sr_inventory_item_id = p_inventory_item_id
447: AND plan_id = -1
448: AND sr_instance_id = p_instance_id;

Line 472: FROM msc_system_items

468: BEGIN
469: /*
470: SELECT inventory_item_id
471: INTO l_inv_item_id
472: FROM msc_system_items
473: WHERE organization_id = p_organization_id
474: AND sr_inventory_item_id = p_inventory_item_id
475: AND plan_id = -1
476: AND sr_instance_id = p_instance_id;

Line 489: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed

485:
486: IF PG_DEBUG in ('Y', 'C') THEN
487: msc_sch_wb.atp_debug('Match item exists');
488: END IF;
489: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
490: -- else go through msc_item_id_lid
491: IF(p_organization_id is not null) THEN
492:
493: SELECT inventory_item_id, inventory_item_id

Line 496: FROM msc_system_items

492:
493: SELECT inventory_item_id, inventory_item_id
494: bulk collect into
495: l_sr_inv_item_id, l_inv_item_ids
496: FROM msc_system_items
497: WHERE organization_id = p_organization_id
498: AND sr_inventory_item_id in (p_inventory_item_id, p_match_item_id)
499: AND plan_id = -1
500: AND sr_instance_id = p_instance_id;

Line 536: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed

532: l_inv_item_id := l_inv_item_ids(l_item_count);
533: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;
534: END LOOP;
535: ELSE
536: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
537: -- else go through msc_item_id_lid
538: IF(p_organization_id is not null) THEN
539:
540: SELECT inventory_item_id

Line 542: FROM msc_system_items

538: IF(p_organization_id is not null) THEN
539:
540: SELECT inventory_item_id
541: INTO l_inv_item_id
542: FROM msc_system_items
543: WHERE organization_id = p_organization_id
544: AND sr_inventory_item_id = p_inventory_item_id
545: AND plan_id = -1
546: AND sr_instance_id = p_instance_id;