[Home] [Help]
70: CURSOR name IS
71: select mtp.organization_code
72: ||':'||mdr.department_code || ':' || mdr.resource_code
73: from msc_department_resources mdr,
74: msc_trading_partners mtp
75: where mdr.department_id = v_dept_id
76: and mdr.resource_id = v_res_id
77: and mdr.plan_id = p_plan_id
78: and mdr.organization_id = v_org_id
2326: bulk collect into
2327: v_dept_code,
2328: v_org, v_instance, v_dept, v_res
2329: FROM msc_department_resources mdr,
2330: msc_trading_partners mtp,
2331: msc_form_query mfq
2332: WHERE mdr.plan_id = p_plan_id
2333: AND mdr.organization_id = mfq.number2
2334: AND mdr.sr_instance_id = mfq.number1
3041: 'mrr.plan_id, mrr.transaction_id, ' ||
3042: ' mrr.sr_instance_id) end_date '||
3043: ' FROM msc_resource_requirements mrr, ' ||
3044: ' msc_supplies ms, ' ||
3045: ' msc_trading_partners mtp ' ||
3046: ' WHERE ms.plan_id = :1 '||
3047: ' and mrr.plan_id = ms.plan_id ' ||
3048: ' and mrr.supply_id = ms.transaction_id ' ||
3049: ' and mrr.sr_instance_id = ms.sr_instance_id ' ||
3076: 'mrr.plan_id, mrr.transaction_id, ' ||
3077: ' mrr.sr_instance_id) end_date '||
3078: ' FROM msc_resource_requirements mrr, ' ||
3079: ' msc_supplies ms, ' ||
3080: ' msc_trading_partners mtp, ' ||
3081: ' msc_exception_details med ' ||
3082: ' WHERE ms.plan_id = :1 '||
3083: ' and mrr.plan_id = ms.plan_id ' ||
3084: ' and mrr.supply_id = ms.transaction_id ' ||
3571:
3572: -- fetch period start date
3573: SELECT greatest(mpsd.period_start_date, mp.data_start_date)
3574: BULK COLLECT INTO v_date
3575: FROM msc_trading_partners tp,
3576: msc_period_start_dates mpsd,
3577: msc_plans mp
3578: WHERE mpsd.calendar_code = tp.calendar_code
3579: and mpsd.sr_instance_id = tp.sr_instance_id
3805: from msc_full_pegging mfp1,
3806: msc_full_pegging mfp2,
3807: msc_supplies ms,
3808: msc_system_items msi,
3809: msc_trading_partners mtp,
3810: msc_form_query mfq
3811: where mfp1.plan_id = p_plan_id
3812: and mfp1.transaction_id = p_supply_id
3813: and mfp1.sr_instance_id = p_instance_id
3862: mfq.number14,
3863: mfq.number15
3864: from msc_form_query mfq,
3865: msc_items mi,
3866: msc_trading_partners mtp
3867: where mfq.query_id = p_query_id
3868: and mfq.number1 = p_supply_id
3869: and mfq.number2 =p_op_seq_num
3870: and mi.inventory_item_id = mfq.number6
4818: msc_full_pegging mfp2,
4819: msc_form_query mfq,
4820: msc_supplies ms,
4821: msc_system_items msi,
4822: msc_trading_partners mtp
4823: where mfp1.pegging_id = mfp2.end_pegging_id
4824: and mfp1.plan_id = mfp2.plan_id
4825: and mfp1.sr_instance_id = mfp2.sr_instance_id
4826: and mfp2.plan_id = p_plan_id
4866: from msc_full_pegging mfp2,
4867: msc_form_query mfq,
4868: msc_supplies ms,
4869: msc_system_items msi,
4870: msc_trading_partners mtp
4871: where mfp2.plan_id = p_plan_id
4872: and mfp2.transaction_id = mfq.number1
4873: and mfp2.sr_instance_id = mfq.number2
4874: and mfq.query_id = g_supply_query_id
5447: mca.calendar_date, mca.calendar_date+1, msc.capacity
5448: bulk collect into v_start, v_end, v_qty
5449: from msc_calendar_dates mca,
5450: msc_plans mp,
5451: msc_trading_partners mtp,
5452: msc_supplier_capacities msc
5453: where msc.plan_id = p_plan_id
5454: and msc.inventory_item_id = v_item_id
5455: and msc.sr_instance_id = v_instance_id
5734: to_char(nvl(md.dmd_satisfied_date,md.using_assembly_demand_date),format_mask),
5735: demand_priority
5736: from msc_demands md,
5737: msc_items mi,
5738: msc_trading_partners mtp
5739: where md.demand_id = p_demand_id
5740: and md.plan_id = p_plan_id
5741: and mi.inventory_item_id = md.inventory_item_id
5742: and mtp.partner_type =3
5781: nvl(ms.supplier_id,-1)
5782: from msc_full_pegging mfp,
5783: msc_supplies ms,
5784: msc_system_items msi,
5785: msc_trading_partners mtp
5786: where mfp.demand_id = p_demand_id
5787: and mfp.plan_id = p_plan_id
5788: and msi.plan_id = ms.plan_id
5789: and msi.organization_id = ms.organization_id
5990: mfq.number1
5991: bulk collect into
5992: v_org_code, v_supplier_name,
5993: v_org, v_instance, v_item, v_supplier
5994: FROM msc_trading_partners mtp,
5995: msc_form_query mfq
5996: where mfq.query_id = g_supplier_query_id
5997: AND mtp.partner_type = 1
5998: AND mtp.partner_id = mfq.number1