[Home] [Help]
188: msc_supplies ms,
189: msc_system_items msi,
190: msc_department_resources mdr,
191: msc_routing_operations mro,
192: msc_trading_partners mtp
193: where mrr.plan_id = ms.plan_id
194: and mrr.sr_instance_id = ms.sr_instance_id
195: and mrr.supply_id = ms.transaction_id
196: and ms.plan_id = msi.plan_id
1471: cursor name is
1472: select mtp.organization_code
1473: ||':'||mdr.department_code || ':' || mdr.resource_code
1474: from msc_department_resources mdr,
1475: msc_trading_partners mtp
1476: where mdr.department_id = p_dept_id
1477: and mdr.resource_id = p_res_id
1478: and mdr.plan_id = p_plan_id
1479: and mdr.organization_id = p_org_id
1486: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)
1487: ||decode(mdri.serial_number, null, null_space, COLON_SEPARATOR || mdri.serial_number)
1488: from msc_dept_res_instances mdri,
1489: msc_department_resources mdr,
1490: msc_trading_partners mtp
1491: where mdr.plan_id = p_plan_id
1492: and mdr.sr_instance_id = p_instance_id
1493: and mdr.organization_id = p_org_id
1494: and mdr.department_id = p_dept_id
1835:
1836: cursor c_plan_cal is
1837: select mtp.calendar_code, mtp.sr_instance_id,
1838: mtp.calendar_exception_set_id, plan_type
1839: from msc_trading_partners mtp,
1840: msc_plans mp
1841: where mp.plan_id = p_plan_id
1842: and mp.sr_instance_id = mtp.sr_instance_id
1843: and mp.organization_id = mtp.sr_tp_id
1876:
1877: -- fetch period start date
1878: select greatest(mpsd.period_start_date, mp.data_start_date)
1879: bulk collect into v_date
1880: from msc_trading_partners tp,
1881: msc_period_start_dates mpsd,
1882: msc_plans mp
1883: where mpsd.calendar_code = tp.calendar_code
1884: and mpsd.sr_instance_id = tp.sr_instance_id
9029: null ORGANIZATION,
9030: msi.item_name ITEM,
9031: null BUYER,
9032: null PLANNER
9033: FROM msc_trading_partners mtp,
9034: --msc_trading_partners mtp2,
9035: msc_trading_partner_sites mtps,
9036: msc_system_items msi,
9037: msc_item_suppliers mis,
9030: msi.item_name ITEM,
9031: null BUYER,
9032: null PLANNER
9033: FROM msc_trading_partners mtp,
9034: --msc_trading_partners mtp2,
9035: msc_trading_partner_sites mtps,
9036: msc_system_items msi,
9037: msc_item_suppliers mis,
9038: msc_gantt_query mgq
9993: md.dmd_satisfied_date material_avail_date
9994: from msc_demands md,
9995: msc_system_items msi,
9996: msc_item_categories mic,
9997: msc_trading_partners mtp,
9998: msc_gantt_query mgq
9999: where mgq.query_id = :p_query_id
10000: and mgq.node_type = :END_DEMAND_NODE
10001: and mgq.row_index between :p_from_index and :p_to_index
10144: ms.actual_start_date
10145: from msc_supplies ms,
10146: msc_system_items msi,
10147: msc_item_categories mic,
10148: msc_trading_partners mtp,
10149: mfg_lookups mfg,
10150: msc_gantt_query mgq
10151: where mgq.query_id = :p_query_id
10152: and mgq.node_type in (:JOB_NODE, :COPROD_NODE)
10365: msc_department_resources mdr,
10366: msc_supplies ms,
10367: msc_items mi,
10368: msc_items mi2,
10369: msc_trading_partners mtp,
10370: msc_gantt_query mgq
10371: where mgq.query_id = :p_query_id
10372: and mgq.node_type = :RES_NODE
10373: and ( ( nvl(:p_res_nodes_only,2) = 2