[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
1470: cursor name is
1471: select mtp.organization_code
1472: ||':'||mdr.department_code || ':' || mdr.resource_code
1473: from msc_department_resources mdr,
1474: msc_trading_partners mtp
1475: where mdr.department_id = p_dept_id
1476: and mdr.resource_id = p_res_id
1477: and mdr.plan_id = p_plan_id
1478: and mdr.organization_id = p_org_id
1485: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)
1486: ||decode(mdri.serial_number, null, null_space, COLON_SEPARATOR || mdri.serial_number)
1487: from msc_dept_res_instances mdri,
1488: msc_department_resources mdr,
1489: msc_trading_partners mtp
1490: where mdr.plan_id = p_plan_id
1491: and mdr.sr_instance_id = p_instance_id
1492: and mdr.organization_id = p_org_id
1493: and mdr.department_id = p_dept_id
1834:
1835: cursor c_plan_cal is
1836: select mtp.calendar_code, mtp.sr_instance_id,
1837: mtp.calendar_exception_set_id, plan_type
1838: from msc_trading_partners mtp,
1839: msc_plans mp
1840: where mp.plan_id = p_plan_id
1841: and mp.sr_instance_id = mtp.sr_instance_id
1842: and mp.organization_id = mtp.sr_tp_id
1875:
1876: -- fetch period start date
1877: select greatest(mpsd.period_start_date, mp.data_start_date)
1878: bulk collect into v_date
1879: from msc_trading_partners tp,
1880: msc_period_start_dates mpsd,
1881: msc_plans mp
1882: where mpsd.calendar_code = tp.calendar_code
1883: and mpsd.sr_instance_id = tp.sr_instance_id
9024: null ORGANIZATION,
9025: msi.item_name ITEM,
9026: null BUYER,
9027: null PLANNER
9028: FROM msc_trading_partners mtp,
9029: --msc_trading_partners mtp2,
9030: msc_trading_partner_sites mtps,
9031: msc_system_items msi,
9032: msc_item_suppliers mis,
9025: msi.item_name ITEM,
9026: null BUYER,
9027: null PLANNER
9028: FROM msc_trading_partners mtp,
9029: --msc_trading_partners mtp2,
9030: msc_trading_partner_sites mtps,
9031: msc_system_items msi,
9032: msc_item_suppliers mis,
9033: msc_gantt_query mgq
9988: md.dmd_satisfied_date material_avail_date
9989: from msc_demands md,
9990: msc_system_items msi,
9991: msc_item_categories mic,
9992: msc_trading_partners mtp,
9993: msc_gantt_query mgq
9994: where mgq.query_id = :p_query_id
9995: and mgq.node_type = :END_DEMAND_NODE
9996: and mgq.row_index between :p_from_index and :p_to_index
10139: ms.actual_start_date
10140: from msc_supplies ms,
10141: msc_system_items msi,
10142: msc_item_categories mic,
10143: msc_trading_partners mtp,
10144: mfg_lookups mfg,
10145: msc_gantt_query mgq
10146: where mgq.query_id = :p_query_id
10147: and mgq.node_type in (:JOB_NODE, :COPROD_NODE)
10360: msc_department_resources mdr,
10361: msc_supplies ms,
10362: msc_items mi,
10363: msc_items mi2,
10364: msc_trading_partners mtp,
10365: msc_gantt_query mgq
10366: where mgq.query_id = :p_query_id
10367: and mgq.node_type = :RES_NODE
10368: and ( ( nvl(:p_res_nodes_only,2) = 2