[Home] [Help]
184: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
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
360: 17, COPROD_NODE,
361: 28, COPROD_NODE,
362: JOB_NODE) nodetype
363: from msc_form_query mfq,
364: msc_supplies ms
365: where mfq.query_id = p_mfq_query_id
366: and mfq.NUMBER2 = ms.sr_instance_id
367: and mfq.NUMBER1 = ms.transaction_id
368: and ms.plan_id = p_plan_id
988: mrr.cummulative_quantity, ms.new_order_quantity
989: into l_mtq,l_cumm_quan, l_order_quan
990: from msc_routing_operations mro,
991: msc_resource_requirements mrr,
992: msc_supplies ms
993: where mrr.plan_id = p_plan_id
994: and mrr.sr_instance_id = p_instance_id
995: and mrr.transaction_id = p_transaction_id
996: and mro.routing_sequence_id = mrr.routing_sequence_id
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
1152: and mrr.sr_instance_id = p_instance_id
1153: and ms.plan_id = mrr.plan_id
2459: g_gantt_rh_toler_days_early,
2460: g_gantt_rh_toler_days_late) display_type
2461: from msc_gantt_query mgq,
2462: msc_resource_requirements mrr,
2463: msc_supplies ms
2464: where mgq.query_id = p_query_id
2465: and mgq.row_flag = SYS_YES
2466: and mgq.is_fetched = SYS_NO
2467: and mgq.res_instance_id = MBP_NULL_VALUE
2513: g_gantt_rh_toler_days_late) display_type
2514: from msc_gantt_query mgq,
2515: msc_resource_requirements mrr,
2516: msc_resource_requirements mrr1,
2517: msc_supplies ms
2518: where mgq.query_id = p_query_id
2519: and mgq.row_flag = SYS_YES
2520: and mgq.is_fetched = SYS_NO
2521: and mgq.res_instance_id = MBP_NULL_VALUE
2580: g_gantt_rh_toler_days_late) display_type
2581: from msc_gantt_query mgq,
2582: msc_resource_requirements mrr,
2583: msc_resource_instance_reqs mrir,
2584: msc_supplies ms
2585: where mgq.query_id = p_query_id
2586: and mgq.row_flag = SYS_YES
2587: and mgq.is_fetched = SYS_NO
2588: and mgq.res_instance_id <> MBP_NULL_VALUE
2651: from msc_gantt_query mgq,
2652: msc_resource_requirements mrr,
2653: msc_resource_requirements mrr1,
2654: msc_resource_instance_reqs mrir,
2655: msc_supplies ms
2656: where mgq.query_id = p_query_id
2657: and mgq.row_flag = SYS_YES
2658: and mgq.is_fetched = SYS_NO
2659: and mgq.res_instance_id <> MBP_NULL_VALUE
2735: g_gantt_rh_toler_days_late)) display_type
2736: from msc_gantt_query mgq,
2737: msc_resource_requirements mrr,
2738: msc_resource_batches mrb,
2739: msc_supplies ms
2740: where mgq.query_id = p_query_id
2741: and mgq.row_flag = SYS_YES
2742: and mgq.is_fetched = SYS_NO
2743: and mgq.res_instance_id = MBP_NULL_VALUE
2813: from msc_gantt_query mgq,
2814: msc_resource_requirements mrr,
2815: msc_resource_requirements mrr1,
2816: msc_resource_batches mrb,
2817: msc_supplies ms
2818: where mgq.query_id = p_query_id
2819: and mgq.row_flag = SYS_YES
2820: and mgq.is_fetched = SYS_NO
2821: and mgq.res_instance_id = MBP_NULL_VALUE
2908: from msc_gantt_query mgq,
2909: msc_resource_requirements mrr,
2910: msc_resource_instance_reqs mrir,
2911: msc_resource_batches mrb,
2912: msc_supplies ms
2913: where mgq.query_id = p_query_id
2914: and mgq.row_flag = SYS_YES
2915: and mgq.is_fetched = SYS_NO
2916: and mgq.res_instance_id <> MBP_NULL_VALUE
3003: msc_resource_requirements mrr,
3004: msc_resource_requirements mrr1,
3005: msc_resource_batches mrb,
3006: msc_resource_instance_reqs mrir,
3007: msc_supplies ms
3008: where mgq.query_id = p_query_id
3009: and mgq.row_flag = SYS_YES
3010: and mgq.is_fetched = SYS_NO
3011: and mgq.res_instance_id <> MBP_NULL_VALUE
3273: mrr.organization_id, ms.inventory_item_id,
3274: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3275: from msc_resource_requirements mrr,
3276: msc_department_resources mdr,
3277: msc_supplies ms,
3278: msc_items mi,
3279: msc_items mi2,
3280: msc_gantt_query mgq,
3281: msc_plan_organizations mpo,
3394: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3395: from msc_resource_instance_reqs mrir,
3396: msc_resource_requirements mrr,
3397: msc_department_resources mdr,
3398: msc_supplies ms,
3399: msc_items mi,
3400: msc_items mi2,
3401: msc_gantt_query mgq
3402: where mgq.query_id = p_query_id
3472: to_char(sum(ms.new_order_quantity)),
3473: to_char(mrr.batch_number),
3474: to_char(sum(mrr.capacity_consumed_ratio))) bar_text
3475: from msc_resource_requirements mrr,
3476: msc_supplies ms,
3477: msc_gantt_query mgq,
3478: msc_plan_organizations mpo,
3479: msc_department_resources mdr,
3480: msc_plans mp
3555: to_char(mrir.batch_number),
3556: to_char(sum(mrir.capacity_consumed_ratio))) bar_text
3557: from msc_resource_instance_reqs mrir,
3558: msc_resource_requirements mrr,
3559: msc_supplies ms,
3560: msc_gantt_query mgq
3561: where mgq.query_id = p_query_id
3562: and mgq.row_flag = SYS_YES
3563: and mgq.is_fetched = SYS_NO
4771: orders_where_stat := 'select sr_instance_id, transaction_id '
4772: ||' from msc_orders_v '
4773: ||' where plan_id = :1 '
4774: ||' and category_set_id = '|| g_category_set_id
4775: ||' and source_table = ''MSC_SUPPLIES'' '
4776: ||' and 1=1 '||p_where;
4777:
4778: elsif (p_filter_type = FILTER_TYPE_AMONG) then
4779: null; --pabram need to check..
4894: p_where;
4895: elsif p_from_block = 'EXCEPTION' then
4896: sql_stat := 'SELECT mrr.sr_instance_id, '||
4897: ' mrr.transaction_id '||
4898: ' FROM msc_supplies mrr, '||
4899: ' msc_exception_details med '||
4900: ' WHERE mrr.plan_id = '||p_plan_id ||
4901: ' and mrr.plan_id = med.plan_id '||
4902: ' and ( (mrr.transaction_id = med.number1 and '||
4919:
4920: else
4921: sql_stat := 'SELECT mrr.sr_instance_id, '||
4922: ' mrr.transaction_id '||
4923: 'FROM msc_supplies mrr '||
4924: ' WHERE mrr.plan_id = '||p_plan_id ||p_where;
4925: end if;
4926:
4927: open the_cursor for sql_stat;
5147: mrr.assigned_units,
5148: mrr.firm_flag
5149: from msc_resource_requirements mrr,
5150: msc_operation_resource_seqs mors,
5151: msc_supplies ms
5152: where mrr.plan_id = p_plan
5153: and mrr.transaction_id = p_trx
5154: and mrr.sr_instance_id = p_inst
5155: and mors.plan_id = mrr.plan_id
5172: mrr.assigned_units,
5173: mrr.firm_flag
5174: from msc_resource_requirements mrr,
5175: msc_job_op_resources mjor,
5176: msc_supplies ms
5177: where mrr.plan_id = p_plan
5178: and mrr.transaction_id = p_trx
5179: and mrr.sr_instance_id = p_inst
5180: and mrr.routing_sequence_id is null
5299: -- 4561112 bugfix
5300: cursor assembly_qty (p_plan number, p_supply number) is
5301: select nvl(assembly_quantity,1) assembly_quantity
5302: from msc_boms mb,
5303: msc_supplies ms,
5304: msc_process_effectivity mpe,
5305: msc_resource_requirements mrr
5306: where ms.plan_id = p_plan
5307: and ms.transaction_id = p_supply
5737: and sr_instance_id = p_inst_id
5738: and batch_number = p_batch_number;
5739:
5740: -- just update MS...we may need to lock in future..
5741: update msc_supplies
5742: set status = 0,
5743: applied = 2
5744: where plan_id = p_plan_id
5745: and sr_instance_id = p_inst_id
5816: and sr_instance_id = p_inst_id
5817: and batch_number = p_batch_number;
5818:
5819: -- just update MS...we may need to lock in future..
5820: update msc_supplies
5821: set status = 0,
5822: applied = 2
5823: where plan_id = p_plan_id
5824: and sr_instance_id = p_inst_id
5912: end loop;
5913: close c_firm_seq_req_row;
5914:
5915: -- just update MS...we may need to lock in future..
5916: update msc_supplies
5917: set status = 0,
5918: applied = 2
5919: where plan_id = p_plan_id
5920: and sr_instance_id = p_inst_id
6343: p_firm_type number default null,
6344: p_firm_date date default null,
6345: p_firm_qty number default null) is
6346: begin
6347: update msc_supplies
6348: set status = 0,
6349: applied = 2,
6350: firm_planned_type = decode(p_update_type,
6351: FIRM_SUPPLY, p_firm_type,
6375: decode(ms.order_type, 27, 1, ms.firm_planned_type) firm_planned_type,
6376: sysdate theDate,
6377: getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time
6378: from msc_resource_requirements mrr,
6379: msc_supplies ms
6380: where mrr.plan_id = p_plan_id
6381: and mrr.sr_instance_id = p_instance_id
6382: and mrr.transaction_id = p_transaction_id
6383: and ms.plan_id = mrr.plan_id
6493: sysdate theDate,
6494: getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time
6495: from msc_resource_requirements mrr,
6496: msc_resource_instance_reqs mrir,
6497: msc_supplies ms
6498: where mrir.plan_id = p_plan_id
6499: and mrir.sr_instance_id = p_instance_id
6500: and mrir.res_inst_transaction_id = p_transaction_id
6501: and mrir.plan_id = mrr.plan_id
7809:
7810: begin
7811: select nvl(new_order_quantity,0)
7812: into l_quan
7813: from msc_supplies
7814: where plan_id = p_plan_id
7815: and transaction_id = p_supply_id
7816: for update of firm_date nowait;
7817: exception
8188: nvl(to_char(ms.UEPSD,format_mask),null_space) UEPSD,
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
8231: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,
8232: nvl(to_char(mrr.ULPSD,format_mask),null_space) ULPSD,
8233: nvl(to_char(mrr.ULPCD,format_mask),null_space) ULPCD
8234: from msc_resource_requirements mrr,
8235: msc_supplies ms,
8236: msc_department_resources mdr
8237: where mrr.plan_id = p_plan_id
8238: and mrr.transaction_id = p_transaction_id
8239: and mrr.sr_instance_id = p_instance_id
8388: nvl(to_char(mrr.UEPSD,format_mask),null_space) UEPSD,
8389: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,
8390: nvl(to_char(mrr.ULPSD,format_mask),null_space) ULPSD,
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
10141: msi.description,
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,
10362: mrr.actual_start_date,
10363: mgq.critical_flag
10364: from msc_resource_requirements mrr,
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