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_REL_PLAN_PUB dependencies on MSC_RESOURCE_REQUIREMENTS

Line 222: msc_resource_requirements mrr

218: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
219: into lv_yield
220: from msc_process_effectivity mpe,
221: msc_routings mr,
222: msc_resource_requirements mrr
223: where mpe.sr_instance_id = inst_id
224: and mpe.plan_id = pln_id
225: and mpe.process_sequence_id = process_seq_id
226: and mr.routing_sequence_id = mpe.routing_sequence_id

Line 235: and mrr.rowid=(select min(rowid) from msc_resource_requirements

231: and mrr.sr_instance_id = mr.sr_instance_id
232: and mrr.OPERATION_SEQ_NUM = mr.FIRST_OP_SEQ_NUM
233: and mrr.supply_id = trans_id
234: and mrr.organization_id = org_id
235: and mrr.rowid=(select min(rowid) from msc_resource_requirements
236: where routing_sequence_id = mr.routing_sequence_id
237: and sr_instance_id = inst_id
238: and plan_id = pln_id
239: and supply_id = trans_id

Line 281: msc_resource_requirements mrr

277: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
278: into lv_yield_dis
279: from msc_process_effectivity mpe,
280: msc_routings mr,
281: msc_resource_requirements mrr
282: where mpe.sr_instance_id = inst_id
283: and mpe.plan_id = pln_id
284: and mpe.process_sequence_id = process_seq_id
285: and mr.routing_sequence_id = mpe.routing_sequence_id

Line 294: from msc_resource_requirements

290: and mrr.sr_instance_id = mr.sr_instance_id
291: and mrr.supply_id = trans_id
292: and mrr.organization_id = org_id
293: and mrr.OPERATION_SEQ_NUM = (select min(OPERATION_SEQ_NUM)
294: from msc_resource_requirements
295: where routing_sequence_id = mr.routing_sequence_id
296: and sr_instance_id = inst_id
297: and plan_id = pln_id
298: and supply_id = trans_id

Line 343: msc_resource_requirements mrr

339: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
340: into lv_yield_dis
341: from msc_process_effectivity mpe,
342: msc_routings mr,
343: msc_resource_requirements mrr
344: where mpe.sr_instance_id = inst_id
345: and mpe.plan_id = pln_id
346: and mpe.process_sequence_id = process_seq_id
347: and mr.routing_sequence_id = mpe.routing_sequence_id

Line 3936: msc_resource_requirements resreq

3932: Begin
3933: SELECT 2
3934: Into lv_agg_details(k)
3935: FROM msc_department_resources deptres,
3936: msc_resource_requirements resreq
3937: WHERE resreq.sr_instance_id= lv_instance_id(k)
3938: AND resreq.supply_id = lv_transaction_id(k)
3939: AND resreq.organization_id= lv_org_id(k)
3940: AND resreq.plan_id = lv_plan_id(k)

Line 4187: msc_resource_requirements res,

4183: 3,
4184: s.sr_instance_id,
4185: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4186: From msc_supplies s,
4187: msc_resource_requirements res,
4188: msc_apps_instances ins,
4189: msc_parameters param
4190: Where res.plan_id = s.plan_id
4191: AND res.sr_instance_id = s.sr_instance_id

Line 4287: msc_resource_requirements res,

4283: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
4284: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4285: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4286: From msc_supplies s,
4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,
4291: msc_system_items msi

Line 4470: msc_resource_requirements res,

4466: , res.orig_resource_seq_num
4467: , res.resource_seq_num
4468: , res.parent_seq_num
4469: From msc_supplies s,
4470: msc_resource_requirements res,
4471: msc_apps_instances ins,
4472: msc_parameters param
4473: Where res.plan_id = s.plan_id
4474: AND res.sr_instance_id = s.sr_instance_id

Line 4563: msc_resource_requirements resreq,

4559: , resreq.resource_id
4560: , 1
4561: FROM
4562: msc_trading_partners tp,
4563: msc_resource_requirements resreq,
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,
4567: msc_apps_instances ins,

Line 4682: msc_resource_requirements resreq,

4678: , resreq.resource_id
4679: , 1
4680: FROM
4681: msc_trading_partners tp,
4682: msc_resource_requirements resreq,
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,
4686: msc_apps_instances ins,

Line 4857: msc_resource_requirements resreq

4853: Begin
4854: SELECT 2
4855: Into lv_agg_details(k)
4856: FROM msc_department_resources deptres,
4857: msc_resource_requirements resreq
4858: WHERE resreq.sr_instance_id= lv_instance_id(k)
4859: AND resreq.supply_id = lv_transaction_id(k)
4860: AND resreq.organization_id= lv_org_id(k)
4861: AND resreq.plan_id = lv_plan_id(k)

Line 5120: msc_resource_requirements res,

5116: 3,
5117: s.sr_instance_id,
5118: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5119: From msc_supplies s,
5120: msc_resource_requirements res,
5121: msc_apps_instances ins,
5122: msc_parameters param
5123: Where res.plan_id = s.plan_id
5124: AND res.sr_instance_id = s.sr_instance_id

Line 5225: msc_resource_requirements res,

5221: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
5222: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5223: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5224: From msc_supplies s,
5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,
5229: msc_system_items msi

Line 5411: msc_resource_requirements res,

5407: res.orig_resource_seq_num,
5408: res.resource_seq_num,
5409: res.parent_seq_num
5410: From msc_supplies s,
5411: msc_resource_requirements res,
5412: msc_apps_instances ins,
5413: msc_parameters param
5414: Where res.plan_id = s.plan_id
5415: AND res.sr_instance_id = s.sr_instance_id

Line 5508: msc_resource_requirements resreq,

5504: 3,
5505: resreq.resource_id,
5506: 1
5507: FROM msc_trading_partners tp,
5508: msc_resource_requirements resreq,
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,
5512: msc_apps_instances ins,

Line 5626: msc_resource_requirements resreq,

5622: , resreq.resource_id
5623: , 1
5624: FROM
5625: msc_trading_partners tp,
5626: msc_resource_requirements resreq,
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,
5630: msc_apps_instances ins,

Line 5934: msc_resource_requirements resreq

5930: Begin
5931: SELECT 2
5932: Into lv_agg_details(k)
5933: FROM msc_department_resources deptres,
5934: msc_resource_requirements resreq
5935: WHERE resreq.sr_instance_id= lv_instance_id(k)
5936: AND resreq.supply_id = lv_transaction_id(k)
5937: AND resreq.organization_id= lv_org_id(k)
5938: AND resreq.plan_id = lv_plan_id(k)

Line 6213: msc_resource_requirements resreq,

6209: 1,
6210: resreq.operation_sequence_id, --Outbound changes for XML
6211: s.sr_instance_id
6212: FROM msc_trading_partners tp,
6213: msc_resource_requirements resreq,
6214: msc_parameters param,
6215: msc_system_items msi,
6216: msc_supplies s
6217: WHERE tp.sr_tp_id= msi.organization_id

Line 6375: msc_resource_requirements resreq,

6371: , resreq.parent_seq_num
6372: , resreq.orig_resource_seq_num
6373: , resreq.resource_seq_num
6374: FROM msc_trading_partners tp,
6375: msc_resource_requirements resreq,
6376: msc_parameters param,
6377: msc_system_items msi,
6378: msc_supplies s,
6379: msc_department_resources mdr

Line 6866: msc_resource_requirements resreq,

6862: resreq.department_id,
6863: resreq.resource_hours,
6864: resreq.parent_seq_num
6865: FROM msc_trading_partners tp,
6866: msc_resource_requirements resreq,
6867: msc_parameters param,
6868: msc_system_items msi,
6869: msc_supplies s,
6870: msc_department_resources mdr

Line 6980: msc_resource_requirements resreq,

6976: , 1 -- jguo
6977: , resreq.parent_seq_num
6978: FROM
6979: msc_trading_partners tp,
6980: msc_resource_requirements resreq,
6981: msc_resource_instance_reqs res_instreq,
6982: msc_dept_res_instances dep_res_inst,
6983: msc_supplies s
6984: WHERE

Line 7092: msc_resource_requirements resreq,

7088: ,1 -- jguo
7089: , resreq.parent_seq_num
7090: FROM
7091: msc_trading_partners tp,
7092: msc_resource_requirements resreq,
7093: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7094: msc_dept_res_instances dep_res_inst,
7095: msc_supplies s
7096: WHERE

Line 7190: msc_resource_requirements resreq,

7186: resreq.RESOURCE_ID,
7187: resreq.resource_seq_num
7188: FROM
7189: msc_trading_partners tp,
7190: msc_resource_requirements resreq,
7191: msc_supplies s,
7192: msc_resource_charges chg
7193: WHERE
7194: tp.sr_tp_id=s.organization_id

Line 7377: msc_resource_requirements resreq

7373: Begin
7374: SELECT 2
7375: Into lv_agg_details(k)
7376: FROM msc_department_resources deptres,
7377: msc_resource_requirements resreq
7378: WHERE resreq.sr_instance_id= lv_instance_id(k)
7379: AND resreq.supply_id = lv_transaction_id(k)
7380: AND resreq.organization_id= lv_org_id(k)
7381: AND resreq.plan_id = lv_plan_id(k)

Line 7618: msc_resource_requirements resreq,

7614: resreq.operation_sequence_id, --Outbound Changes for XML
7615: s.disposition_id
7616: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
7617: FROM msc_trading_partners tp,
7618: msc_resource_requirements resreq,
7619: msc_parameters param,
7620: msc_system_items msi,
7621: msc_supplies s
7622: WHERE tp.sr_tp_id= msi.organization_id

Line 7767: msc_resource_requirements resreq,

7763: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7764: , resreq.orig_resource_seq_num
7765: , resreq.resource_seq_num
7766: FROM msc_trading_partners tp,
7767: msc_resource_requirements resreq,
7768: msc_parameters param,
7769: msc_system_items msi,
7770: msc_supplies s
7771: WHERE tp.sr_tp_id= msi.organization_id

Line 8115: msc_resource_requirements resreq,

8111: , resreq.orig_resource_seq_num
8112: , resreq.resource_seq_num
8113: ,resreq.parent_seq_num
8114: FROM msc_trading_partners tp,
8115: msc_resource_requirements resreq,
8116: msc_parameters param,
8117: msc_system_items msi,
8118: msc_supplies s
8119: WHERE tp.sr_tp_id= msi.organization_id

Line 8223: msc_resource_requirements resreq,

8219: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8220: , resreq.parent_seq_num
8221: FROM
8222: msc_trading_partners tp,
8223: msc_resource_requirements resreq,
8224: msc_resource_instance_reqs res_instreq,
8225: msc_dept_res_instances dep_res_inst,
8226: msc_supplies s
8227: WHERE

Line 8341: msc_resource_requirements resreq,

8337: , 1 -- jguo
8338: ,resreq.parent_seq_num
8339: FROM
8340: msc_trading_partners tp,
8341: msc_resource_requirements resreq,
8342: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
8343: msc_dept_res_instances dep_res_inst,
8344: msc_supplies s
8345: WHERE

Line 8445: msc_resource_requirements resreq,

8441: , resreq.RESOURCE_ID
8442: , resreq.resource_seq_num
8443: FROM
8444: msc_trading_partners tp,
8445: msc_resource_requirements resreq,
8446: msc_supplies s,
8447: msc_resource_charges chg
8448: WHERE
8449: tp.sr_tp_id=s.organization_id