[Home] [Help]
185: mdr.department_code,
186: mdr.resource_code
187: from msc_resource_requirements mrr,
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
603: p_bom_item_type out nocopy number, p_base_item_id out nocopy varchar2) is
604:
605: cursor c_bom_item is
606: select bom_item_type, base_item_id
607: from msc_system_items
608: where plan_id = p_plan_id
609: and inventory_item_id = p_item_id;
610: begin
611: open c_bom_item;
1143: select getResReqStartDate(nvl(mrr.firm_flag,0),
1144: mrr.start_date, mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied) start_date,
1145: msi.planning_time_fence_date
1146: into l_prev_start_date, l_timefence_date
1147: from msc_system_items msi,
1148: msc_resource_requirements mrr,
1149: msc_supplies ms
1150: where mrr.plan_id = p_plan_id
1151: and mrr.transaction_id = p_transaction_id
4049: sum(msr.consumed_quantity) consumed_qty
4050: bulk collect into v_row_index, v_start_date, v_overload_qty, v_consumed_qty
4051: from msc_gantt_query mgq,
4052: msc_supplier_requirements msr,
4053: msc_system_items msi
4054: where mgq.query_id = p_query_id
4055: and mgq.row_flag = SYS_YES
4056: and mgq.is_fetched = SYS_NO
4057: and mgq.dependency_type = 1 -- bom_item_type, MODELs
8189: nvl(to_char(ms.UEPCD,format_mask),null_space) UEPCD,
8190: nvl(to_char(ms.ULPSD,format_mask),null_space) ULPSD,
8191: nvl(to_char(ms.ULPCD,format_mask),null_space) ULPCD
8192: from msc_supplies ms,
8193: msc_system_items msi
8194: where ms.plan_id = p_plan_id
8195: and ms.transaction_id = p_transaction_id
8196: and ms.sr_instance_id = p_instance_id
8197: and msi.plan_id = ms.plan_id
8391: nvl(to_char(mrr.ULPCD,format_mask),null_space) ULPCD
8392: from msc_supplies ms,
8393: msc_resource_requirements mrr,
8394: msc_department_resources mdr,
8395: msc_system_items msi,
8396: msc_process_effectivity pe
8397: where pe.plan_id(+) = ms.plan_id
8398: and pe.sr_instance_id(+) = ms.sr_instance_id
8399: and pe.process_sequence_id(+) = ms.process_seq_id
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
9039: WHERE mgq.query_id = :p_query_id
9040: and mis.plan_id = mgq.plan_id
9991: md.inventory_item_id,
9992: md.demand_class,
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
10142: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10143: ms.new_schedule_date,
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