[Home] [Help]
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;
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
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;
314: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting item type for PDS');
315: END IF;
316: SELECT i.bom_item_type
317: INTO l_item_type
318: FROM msc_system_items i
319: WHERE i.plan_id = p_plan_id
320: AND i.sr_instance_id = p_instance_id
321: AND i.organization_id = p_organization_id
322: AND i.sr_inventory_item_id = p_inventory_item_id;
342: FROM msc_calendar_dates c2,
343: msc_calendar_dates c1,
344: msc_atp_rules r,
345: msc_trading_partners tp,
346: msc_system_items i
347: WHERE i.sr_inventory_item_id = p_inventory_item_id
348: AND i.organization_id = p_organization_id
349: --AND i.plan_id = p_plan_id
350: AND i.plan_id = -1 -- for 1478110
448: BEGIN
449:
450: SELECT substr(ITEM_NAME, 1, 40)
451: INTO l_inv_item_name
452: FROM msc_system_items
453: WHERE organization_id = p_organization_id
454: AND sr_inventory_item_id = p_inventory_item_id
455: AND plan_id = -1
456: AND sr_instance_id = p_instance_id;
476: BEGIN
477: /*
478: SELECT inventory_item_id
479: INTO l_inv_item_id
480: FROM msc_system_items
481: WHERE organization_id = p_organization_id
482: AND sr_inventory_item_id = p_inventory_item_id
483: AND plan_id = -1
484: AND sr_instance_id = p_instance_id;
493:
494: IF PG_DEBUG in ('Y', 'C') THEN
495: msc_sch_wb.atp_debug('Match item exists');
496: END IF;
497: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
498: -- else go through msc_item_id_lid
499: IF(p_organization_id is not null) THEN
500:
501: SELECT inventory_item_id, inventory_item_id
500:
501: SELECT inventory_item_id, inventory_item_id
502: bulk collect into
503: l_sr_inv_item_id, l_inv_item_ids
504: FROM msc_system_items
505: WHERE organization_id = p_organization_id
506: AND sr_inventory_item_id in (p_inventory_item_id, p_match_item_id)
507: AND plan_id = -1
508: AND sr_instance_id = p_instance_id;
540: l_inv_item_id := l_inv_item_ids(l_item_count);
541: EXIT WHEN l_sr_inv_item_id(l_item_count) = p_match_item_id;
542: END LOOP;
543: ELSE
544: --bug 4091487 Added the if condition to drive query from msc_system_items in case organization id is passed
545: -- else go through msc_item_id_lid
546: IF(p_organization_id is not null) THEN
547:
548: SELECT inventory_item_id
546: IF(p_organization_id is not null) THEN
547:
548: SELECT inventory_item_id
549: INTO l_inv_item_id
550: FROM msc_system_items
551: WHERE organization_id = p_organization_id
552: AND sr_inventory_item_id = p_inventory_item_id
553: AND plan_id = -1
554: AND sr_instance_id = p_instance_id;
1051:
1052: SELECT Count(1)
1053: INTO l_count
1054: FROM msc_item_hierarchy_mv mv,
1055: msc_system_items item
1056: WHERE item.sr_instance_id = p_instance_id
1057: and item.sr_inventory_item_id = p_inventory_item_id
1058: and item.organization_id = p_organization_id
1059: and item.plan_id = p_plan_id