APPS.MSC_MATL_PLAN_PKG dependencies on MSC_DEMANDS

Line 367: msc_demands md,

363: end) other_demand,
364:
365: to_number(null) safety_stock
366: from
367: msc_demands md,
368: msc_hp_col_dtls b,
369: msc_hp_row_dtls h
370: where h.query_id = p_query_id
371: and md.plan_id = h.plan_id

Line 594: from msc_demands

590: applied,
591: last_update_date,
592: last_updated_by,
593: last_update_login
594: from msc_demands
595: where plan_id = p_plan_id
596: and sr_instance_id = p_sr_instance_id
597: and organization_id = p_organization_id
598: and inventory_item_id = p_inventory_item_id

Line 718: from msc_demands

714: nvl(firm_quantity, using_requirement_quantity), null)), 0) old_value,
715: nvl(sum(decode(assembly_demand_comp_date, null, null, daily_demand_rate)), 0) fixed,
716: nvl(sum(decode(assembly_demand_comp_date, null, 1, 0)), 0) cnt
717: into l_old_value, l_fixed, l_cnt
718: from msc_demands
719: where plan_id = ru.plan_id
720: and sr_instance_id = ru.sr_instance_id
721: and organization_id = ru.organization_id
722: and inventory_item_id = ru.inventory_item_id

Line 738: update msc_demands set

734: ru.start_date,
735: ru.end_date,
736: ru.demand_type)
737: loop
738: update msc_demands set
739: firm_date = nvl(firm_date, using_assembly_demand_date),
740: firm_quantity = decode(l_old_value, 0, (ru.new_value-l_fixed)/l_cnt,
741: nvl(firm_quantity, using_requirement_quantity)*(ru.new_value-l_fixed)/l_old_value),
742: org_firm_flag = 1,

Line 753: msc_phub_util.log('update msc_demands: '||l_n);

749: l_n := l_n + 1;
750: end loop;
751:
752: if (l_n > 0) then
753: msc_phub_util.log('update msc_demands: '||l_n);
754: else
755: insert into msc_demands(
756: plan_id,
757: demand_id,

Line 755: insert into msc_demands(

751:
752: if (l_n > 0) then
753: msc_phub_util.log('update msc_demands: '||l_n);
754: else
755: insert into msc_demands(
756: plan_id,
757: demand_id,
758: sr_instance_id,
759: organization_id,

Line 776: msc_demands_s.nextval,

772: created_by, creation_date,
773: last_update_date, last_updated_by, last_update_login)
774: values(
775: ru.plan_id,
776: msc_demands_s.nextval,
777: ru.sr_instance_id,
778: ru.organization_id,
779: ru.inventory_item_id,
780: ru.demand_type,

Line 793: msc_phub_util.log('insert into msc_demands: '||sql%rowcount);

789: 0,
790: 2,
791: fnd_global.user_id, sysdate,
792: sysdate, fnd_global.user_id, fnd_global.login_id);
793: msc_phub_util.log('insert into msc_demands: '||sql%rowcount);
794: end if;
795: commit;
796: end if;
797: end loop;