APPS.MSC_MATL_PLAN_PKG dependencies on MSC_SUPPLIES

Line 235: msc_supplies ms,

231: to_number(null) sales_order,
232: to_number(null) other_demand,
233: to_number(null) safety_stock
234: from
235: msc_supplies ms,
236: msc_hp_col_dtls b,
237: msc_hp_row_dtls h
238: where h.query_id = p_query_id
239: and ms.plan_id = h.plan_id

Line 300: msc_supplies ms,

296: to_number(null) sales_order,
297: to_number(null) other_demand,
298: to_number(null) safety_stock
299: from
300: msc_supplies ms,
301: msc_hp_col_dtls b,
302: msc_hp_row_dtls h
303: where h.query_id = p_query_id
304: and ms.plan_id = h.plan_id

Line 567: from msc_supplies

563: applied,
564: last_update_date,
565: last_updated_by,
566: last_update_login
567: from msc_supplies
568: where plan_id = p_plan_id
569: and sr_instance_id = p_sr_instance_id
570: and organization_id = p_organization_id
571: and inventory_item_id = p_inventory_item_id

Line 629: from msc_supplies

625: nvl(firm_quantity, new_order_quantity), null)), 0) old_value,
626: nvl(sum(decode(last_unit_completion_date, null, null, daily_rate)), 0) fixed,
627: nvl(sum(decode(last_unit_completion_date, null, 1, 0)), 0) cnt
628: into l_old_value, l_fixed, l_cnt
629: from msc_supplies
630: where plan_id = ru.plan_id
631: and sr_instance_id = ru.sr_instance_id
632: and organization_id = ru.organization_id
633: and inventory_item_id = ru.inventory_item_id

Line 649: update msc_supplies set

645: ru.start_date,
646: ru.end_date,
647: ru.supply_type)
648: loop
649: update msc_supplies set
650: firm_planned_type = 1,
651: firm_date = nvl(firm_date, new_schedule_date),
652: firm_quantity = decode(l_old_value, 0, (ru.new_value-l_fixed)/l_cnt,
653: nvl(firm_quantity, new_order_quantity)*(ru.new_value-l_fixed)/l_old_value),

Line 664: msc_phub_util.log('update msc_supplies: '||l_n);

660: l_n := l_n + 1;
661: end loop;
662:
663: if (l_n > 0) then
664: msc_phub_util.log('update msc_supplies: '||l_n);
665: else
666: insert into msc_supplies(
667: plan_id,
668: transaction_id,

Line 666: insert into msc_supplies(

662:
663: if (l_n > 0) then
664: msc_phub_util.log('update msc_supplies: '||l_n);
665: else
666: insert into msc_supplies(
667: plan_id,
668: transaction_id,
669: sr_instance_id,
670: organization_id,

Line 683: msc_supplies_s.nextval,

679: created_by, creation_date,
680: last_update_date, last_updated_by, last_update_login)
681: values(
682: ru.plan_id,
683: msc_supplies_s.nextval,
684: ru.sr_instance_id,
685: ru.organization_id,
686: ru.inventory_item_id,
687: ru.supply_type,

Line 696: msc_phub_util.log('insert into msc_supplies: '||sql%rowcount);

692: 0,
693: 2,
694: fnd_global.user_id, sysdate,
695: sysdate, fnd_global.user_id, fnd_global.login_id);
696: msc_phub_util.log('insert into msc_supplies: '||sql%rowcount);
697: end if;
698: commit;
699: end if;
700: