[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
602: p_bom_item_type out nocopy number, p_base_item_id out nocopy varchar2) is
603:
604: cursor c_bom_item is
605: select bom_item_type, base_item_id
606: from msc_system_items
607: where plan_id = p_plan_id
608: and inventory_item_id = p_item_id;
609: begin
610: open c_bom_item;
1142: select getResReqStartDate(nvl(mrr.firm_flag,0),
1143: mrr.start_date, mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied) start_date,
1144: msi.planning_time_fence_date
1145: into l_prev_start_date, l_timefence_date
1146: from msc_system_items msi,
1147: msc_resource_requirements mrr,
1148: msc_supplies ms
1149: where mrr.plan_id = p_plan_id
1150: and mrr.transaction_id = p_transaction_id
4044: sum(msr.consumed_quantity) consumed_qty
4045: bulk collect into v_row_index, v_start_date, v_overload_qty, v_consumed_qty
4046: from msc_gantt_query mgq,
4047: msc_supplier_requirements msr,
4048: msc_system_items msi
4049: where mgq.query_id = p_query_id
4050: and mgq.row_flag = SYS_YES
4051: and mgq.is_fetched = SYS_NO
4052: and mgq.dependency_type = 1 -- bom_item_type, MODELs
8184: nvl(to_char(ms.UEPCD,format_mask),null_space) UEPCD,
8185: nvl(to_char(ms.ULPSD,format_mask),null_space) ULPSD,
8186: nvl(to_char(ms.ULPCD,format_mask),null_space) ULPCD
8187: from msc_supplies ms,
8188: msc_system_items msi
8189: where ms.plan_id = p_plan_id
8190: and ms.transaction_id = p_transaction_id
8191: and ms.sr_instance_id = p_instance_id
8192: and msi.plan_id = ms.plan_id
8386: nvl(to_char(mrr.ULPCD,format_mask),null_space) ULPCD
8387: from msc_supplies ms,
8388: msc_resource_requirements mrr,
8389: msc_department_resources mdr,
8390: msc_system_items msi,
8391: msc_process_effectivity pe
8392: where pe.plan_id(+) = ms.plan_id
8393: and pe.sr_instance_id(+) = ms.sr_instance_id
8394: and pe.process_sequence_id(+) = ms.process_seq_id
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
9034: WHERE mgq.query_id = :p_query_id
9035: and mis.plan_id = mgq.plan_id
9986: md.inventory_item_id,
9987: md.demand_class,
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
10137: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10138: ms.new_schedule_date,
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