eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_GANTT_DATA dependencies on MSC_SUPPLIES

Line 190: msc_supplies ms,

186: decode(sign(ms.new_schedule_date - (ms.need_by_date+1)), 1,
187: 1,0) late_flag,
188: mrr.supply_id
189: from msc_resource_requirements mrr,
190: msc_supplies ms,
191: msc_items msi,
192: mfg_lookups mfg
193: where mrr.organization_id =v_org_id
194: and mrr.sr_instance_id = v_instance_id

Line 248: msc_supplies ms,

244: decode(sign(ms.new_schedule_date - (ms.need_by_date+1)), 1,
245: 1,0) late_flag,
246: mrr.supply_id
247: from msc_resource_requirements mrr,
248: msc_supplies ms,
249: msc_items msi,
250: mfg_lookups mfg,
251: msc_form_query mfq
252: where mrr.organization_id =v_org_id

Line 1210: from msc_supplies

1206:
1207: IF l_basis_type = 1 THEN
1208: select new_order_quantity
1209: into v_qty
1210: from msc_supplies
1211: where plan_id = p_plan_id
1212: and transaction_id = l_supply_id;
1213: ELSE
1214: v_qty := 1;

Line 1443: update msc_supplies

1439: i := i+1;
1440: end loop;
1441: end LOOP;
1442:
1443: update msc_supplies
1444: set status = 0, applied = 2
1445: where plan_id = p_plan_id
1446: and transaction_id = l_supply_id;
1447:

Line 1560: update msc_supplies

1556: where plan_id = p_plan_id
1557: and transaction_id = p_transaction_id
1558: and sr_instance_id = p_instance_id;
1559:
1560: update msc_supplies
1561: set status =0,
1562: applied=2
1563: where plan_id = p_plan_id
1564: and transaction_id = l_supply_id;

Line 1858: FROM msc_supplies ms,

1854: nvl(to_char(mrr.UEPSD,format_mask),'null') UEPSD,
1855: nvl(to_char(mrr.UEPCD,format_mask),'null') UEPCD,
1856: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
1857: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
1858: FROM msc_supplies ms,
1859: msc_resource_requirements mrr,
1860: msc_department_resources mdr,
1861: msc_system_items msi,
1862: msc_process_effectivity pe

Line 2370: msc_supplies ms

2366: mrr.cummulative_quantity, ms.new_order_quantity
2367: into l_mtq,l_cumm_quan, l_order_quan
2368: from msc_routing_operations mro,
2369: msc_resource_requirements mrr,
2370: msc_supplies ms
2371: where mrr.plan_id = p_plan_id
2372: and mrr.sr_instance_id = p_instance_id
2373: and mrr.transaction_id = p_transaction_id
2374: and mro.routing_sequence_id = mrr.routing_sequence_id

Line 2415: msc_supplies ms

2411: 1, ms.firm_planned_type) firm_planned_type,
2412: sysdate theDate,
2413: get_MTQ_time(p_transaction_id, p_plan_id, p_instance_id) mtq_time
2414: FROM msc_resource_requirements mrr,
2415: msc_supplies ms
2416: WHERE mrr.plan_id = p_plan_id
2417: and mrr.transaction_id = p_transaction_id
2418: and mrr.sr_instance_id = p_instance_id
2419: and ms.plan_id = mrr.plan_id

Line 2712: msc_supplies ms

2708: msi.PLANNING_TIME_FENCE_DATE
2709: into l_prev_start_date, l_timefence_date
2710: from msc_system_items msi,
2711: msc_resource_requirements mrr,
2712: msc_supplies ms
2713: where mrr.plan_id = p_plan_id
2714: and mrr.transaction_id = p_transaction_id
2715: and mrr.sr_instance_id = p_instance_id
2716: AND ms.plan_id = mrr.plan_id

Line 2932: update msc_supplies

2928: where plan_id = p_plan_id
2929: and transaction_id = p_transaction_id
2930: and sr_instance_id = p_instance_id;
2931:
2932: update msc_supplies
2933: set status =0,
2934: applied=2
2935: where plan_id = p_plan_id
2936: and transaction_id = l_supply_id;

Line 3044: ' msc_supplies ms, ' ||

3040: ' msc_get_gantt_data.get_end_date( ' ||
3041: 'mrr.plan_id, mrr.transaction_id, ' ||
3042: ' mrr.sr_instance_id) end_date '||
3043: ' FROM msc_resource_requirements mrr, ' ||
3044: ' msc_supplies ms, ' ||
3045: ' msc_trading_partners mtp ' ||
3046: ' WHERE ms.plan_id = :1 '||
3047: ' and mrr.plan_id = ms.plan_id ' ||
3048: ' and mrr.supply_id = ms.transaction_id ' ||

Line 3079: ' msc_supplies ms, ' ||

3075: ' msc_get_gantt_data.get_end_date( ' ||
3076: 'mrr.plan_id, mrr.transaction_id, ' ||
3077: ' mrr.sr_instance_id) end_date '||
3078: ' FROM msc_resource_requirements mrr, ' ||
3079: ' msc_supplies ms, ' ||
3080: ' msc_trading_partners mtp, ' ||
3081: ' msc_exception_details med ' ||
3082: ' WHERE ms.plan_id = :1 '||
3083: ' and mrr.plan_id = ms.plan_id ' ||

Line 3238: ' FROM msc_supplies mrr, '||

3234: sql_stat :=
3235: 'SELECT mrr.sr_instance_id, '||
3236: ' mrr.transaction_id '||
3237: -- ' med.exception_detail_id '||
3238: ' FROM msc_supplies mrr, '||
3239: ' msc_exception_details med '||
3240: ' WHERE mrr.plan_id = '||p_plan_id ||
3241: ' and mrr.plan_id = med.plan_id '||
3242: ' and ( (mrr.transaction_id = med.number1 and '||

Line 3264: 'FROM msc_supplies mrr '||

3260:
3261: else
3262: sql_stat := 'SELECT mrr.sr_instance_id, '||
3263: ' mrr.transaction_id '||
3264: 'FROM msc_supplies mrr '||
3265: ' WHERE mrr.plan_id = '||p_plan_id ||p_where;
3266: end if;
3267:
3268: OPEN the_cursor FOR sql_stat;

Line 3667: FROM msc_supplies

3663:
3664: BEGIN
3665: SELECT nvl(new_order_quantity,0)
3666: INTO l_quan
3667: FROM msc_supplies
3668: WHERE plan_id = p_plan_id
3669: AND transaction_id = p_supply_id
3670: FOR UPDATE OF firm_date NOWAIT;
3671: EXCEPTION WHEN app_exception.record_lock_exception THEN

Line 3676: UPDATE msc_supplies

3672: p_return_status := 'ERROR';
3673: return;
3674: END;
3675: -- now update
3676: UPDATE msc_supplies
3677: SET firm_date = to_date(p_end, format_mask), firm_quantity = l_quan,
3678: applied = 2, status = 0, firm_planned_type = 1
3679: WHERE plan_id = p_plan_id
3680: AND transaction_id = p_supply_id;

Line 3807: msc_supplies ms,

3803: ms.inventory_item_id,
3804: nvl(ms.supplier_id,-1)
3805: from msc_full_pegging mfp1,
3806: msc_full_pegging mfp2,
3807: msc_supplies ms,
3808: msc_system_items msi,
3809: msc_trading_partners mtp,
3810: msc_form_query mfq
3811: where mfp1.plan_id = p_plan_id

Line 3915: msc_supplies ms

3911: msc_get_gantt_data.isCriticalRes(p_plan_id,g_end_demand_id,
3912: ms.transaction_id, ms.sr_instance_id,
3913: mrr.operation_seq_num, mrr.routing_sequence_id))
3914: from msc_resource_requirements mrr,
3915: msc_supplies ms
3916: where mrr.plan_id = p_plan_id
3917: and mrr.supply_id = p_supply_id
3918: and mrr.parent_id =2
3919: and mrr.operation_seq_num = p_op_seq

Line 3939: from msc_supplies

3935: to_char(decode(nvl(firm_planned_type,2),2,
3936: new_schedule_date,nvl(firm_date,new_schedule_date)),
3937: format_mask),
3938: nvl(firm_planned_type,2)
3939: from msc_supplies
3940: where plan_id = p_plan_id
3941: and transaction_id = p_supply_id;
3942:
3943: i number;

Line 4278: msc_supplies ms,

4274: ms.inventory_item_id,
4275: nvl(ms.supplier_id,-1)
4276: from msc_full_pegging mfp1,
4277: msc_full_pegging mfp2,
4278: msc_supplies ms,
4279: msc_demands md,
4280: msc_system_items msi,
4281: msc_critical_paths mcp,
4282: msc_form_query mfq

Line 4399: msc_supplies ms,

4395: nvl(ms.supplier_id,-1)
4396: from msc_full_pegging mfp1,
4397: msc_full_pegging mfp2,
4398: msc_system_items msi,
4399: msc_supplies ms,
4400: msc_demands md,
4401: msc_form_query mfq
4402: where mfp1.plan_id = p_plan_id
4403: and mfp1.transaction_id = p_supply_id

Line 4820: msc_supplies ms,

4816: ms.source_organization_id)
4817: from msc_full_pegging mfp1,
4818: msc_full_pegging mfp2,
4819: msc_form_query mfq,
4820: msc_supplies ms,
4821: msc_system_items msi,
4822: msc_trading_partners mtp
4823: where mfp1.pegging_id = mfp2.end_pegging_id
4824: and mfp1.plan_id = mfp2.plan_id

Line 4868: msc_supplies ms,

4864: ms.organization_id,
4865: ms.source_organization_id)
4866: from msc_full_pegging mfp2,
4867: msc_form_query mfq,
4868: msc_supplies ms,
4869: msc_system_items msi,
4870: msc_trading_partners mtp
4871: where mfp2.plan_id = p_plan_id
4872: and mfp2.transaction_id = mfq.number1

Line 5142: FROM msc_supplies ms,

5138: nvl(to_char(ms.UEPSD,format_mask),'null') UEPSD,
5139: nvl(to_char(ms.UEPCD,format_mask),'null') UEPCD,
5140: nvl(to_char(ms.ULPSD,format_mask),'null') ULPSD,
5141: nvl(to_char(ms.ULPCD,format_mask),'null') ULPCD
5142: FROM msc_supplies ms,
5143: msc_system_items msi
5144: WHERE ms.plan_id = p_plan_id
5145: AND ms.transaction_id = p_transaction_id
5146: and ms.sr_instance_id = p_instance_id

Line 5190: msc_supplies ms,

5186: nvl(to_char(mrr.UEPCD,format_mask),'null') UEPCD,
5187: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
5188: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
5189: FROM msc_resource_requirements mrr,
5190: msc_supplies ms,
5191: msc_department_resources mdr
5192: WHERE mrr.plan_id = p_plan_id
5193: AND mrr.transaction_id = p_transaction_id
5194: and mrr.sr_instance_id = p_instance_id

Line 5512: from msc_supplies ms

5508:
5509: select trunc(ms.new_dock_date), trunc(ms.new_dock_date)+1,
5510: ms.new_order_quantity
5511: bulk collect into v_start, v_end, v_qty
5512: from msc_supplies ms
5513: where ms.plan_id = p_plan_id
5514: and ms.inventory_item_id = v_item_id
5515: and ms.sr_instance_id = v_instance_id
5516: and ms.supplier_id = v_supplier_id

Line 5783: msc_supplies ms,

5779: mtp.organization_code ||':'||msi.item_name,
5780: ms.inventory_item_id,
5781: nvl(ms.supplier_id,-1)
5782: from msc_full_pegging mfp,
5783: msc_supplies ms,
5784: msc_system_items msi,
5785: msc_trading_partners mtp
5786: where mfp.demand_id = p_demand_id
5787: and mfp.plan_id = p_plan_id

Line 6200: from msc_supplies ms

6196: msc_get_gantt_data.get_dmd_priority(
6197: ms.plan_id, ms.sr_instance_id, ms.transaction_id)),
6198: ms.new_order_quantity
6199: bulk collect into v_id,v_qty
6200: from msc_supplies ms
6201: where ms.plan_id = p_plan_id
6202: and ms.inventory_item_id = p_item_id
6203: and ms.sr_instance_id = p_instance_id
6204: and ms.supplier_id = p_supplier_id

Line 6269: msc_supplies ms

6265: mrr.plan_id, mrr.sr_instance_id, mrr.supply_id)),
6266: mrr.resource_hours/24/v_bkt_size
6267: bulk collect into v_id,v_qty
6268: from msc_resource_requirements mrr,
6269: msc_supplies ms
6270: where mrr.plan_id = p_plan_id
6271: and mrr.department_id = p_dept_id
6272: and mrr.sr_instance_id = p_instance_id
6273: and mrr.resource_id = p_resource_id

Line 6546: from msc_supplies

6542: return varchar2 IS
6543: v_text varchar2(300);
6544: cursor order_c is
6545: select order_number
6546: from msc_supplies
6547: where plan_id = p_plan_id
6548: and transaction_id = p_disposition_id
6549: and sr_instance_id = p_inst_id;
6550: BEGIN