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 230: msc_resource_requirements mrr

226: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
227: into lv_yield
228: from msc_process_effectivity mpe,
229: msc_routings mr,
230: msc_resource_requirements mrr
231: where mpe.sr_instance_id = inst_id
232: and mpe.plan_id = pln_id
233: and mpe.process_sequence_id = process_seq_id
234: and mr.routing_sequence_id = mpe.routing_sequence_id

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

239: and mrr.sr_instance_id = mr.sr_instance_id
240: and mrr.OPERATION_SEQ_NUM = mr.FIRST_OP_SEQ_NUM
241: and mrr.supply_id = trans_id
242: and mrr.organization_id = org_id
243: and mrr.rowid=(select min(rowid) from msc_resource_requirements
244: where routing_sequence_id = mr.routing_sequence_id
245: and sr_instance_id = inst_id
246: and plan_id = pln_id
247: and supply_id = trans_id

Line 289: msc_resource_requirements mrr

285: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
286: into lv_yield_dis
287: from msc_process_effectivity mpe,
288: msc_routings mr,
289: msc_resource_requirements mrr
290: where mpe.sr_instance_id = inst_id
291: and mpe.plan_id = pln_id
292: and mpe.process_sequence_id = process_seq_id
293: and mr.routing_sequence_id = mpe.routing_sequence_id

Line 302: from msc_resource_requirements

298: and mrr.sr_instance_id = mr.sr_instance_id
299: and mrr.supply_id = trans_id
300: and mrr.organization_id = org_id
301: and mrr.OPERATION_SEQ_NUM = (select min(OPERATION_SEQ_NUM)
302: from msc_resource_requirements
303: where routing_sequence_id = mr.routing_sequence_id
304: and sr_instance_id = inst_id
305: and plan_id = pln_id
306: and supply_id = trans_id

Line 351: msc_resource_requirements mrr

347: select nvl(mrr.REVERSE_CUMULATIVE_YIELD,1)
348: into lv_yield_dis
349: from msc_process_effectivity mpe,
350: msc_routings mr,
351: msc_resource_requirements mrr
352: where mpe.sr_instance_id = inst_id
353: and mpe.plan_id = pln_id
354: and mpe.process_sequence_id = process_seq_id
355: and mr.routing_sequence_id = mpe.routing_sequence_id

Line 4485: msc_resource_requirements resreq

4481: Begin
4482: SELECT 2
4483: Into lv_agg_details(k)
4484: FROM msc_department_resources deptres,
4485: msc_resource_requirements resreq
4486: WHERE resreq.sr_instance_id= lv_instance_id(k)
4487: AND resreq.supply_id = lv_transaction_id(k)
4488: AND resreq.organization_id= lv_org_id(k)
4489: AND resreq.plan_id = lv_plan_id(k)

Line 4736: msc_resource_requirements res,

4732: 3,
4733: s.sr_instance_id,
4734: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4735: From msc_supplies s,
4736: msc_resource_requirements res,
4737: msc_apps_instances ins,
4738: msc_parameters param
4739: Where res.plan_id = s.plan_id
4740: AND res.sr_instance_id = s.sr_instance_id

Line 4836: msc_resource_requirements res,

4832: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
4833: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4834: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4835: From msc_supplies s,
4836: msc_resource_requirements res,
4837: msc_apps_instances ins,
4838: msc_parameters param,
4839: msc_department_resources mdr,
4840: msc_system_items msi

Line 5019: msc_resource_requirements res,

5015: , res.orig_resource_seq_num
5016: , res.resource_seq_num
5017: , res.parent_seq_num
5018: From msc_supplies s,
5019: msc_resource_requirements res,
5020: msc_apps_instances ins,
5021: msc_parameters param
5022: Where res.plan_id = s.plan_id
5023: AND res.sr_instance_id = s.sr_instance_id

Line 5112: msc_resource_requirements resreq,

5108: , resreq.resource_id
5109: , 1
5110: FROM
5111: msc_trading_partners tp,
5112: msc_resource_requirements resreq,
5113: msc_resource_instance_reqs res_instreq, -- changed from design doc
5114: msc_dept_res_instances dep_res_inst,
5115: msc_supplies s,
5116: msc_apps_instances ins,

Line 5231: msc_resource_requirements resreq,

5227: , resreq.resource_id
5228: , 1
5229: FROM
5230: msc_trading_partners tp,
5231: msc_resource_requirements resreq,
5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,
5235: msc_apps_instances ins,

Line 5413: msc_resource_requirements resreq

5409: Begin
5410: SELECT 2
5411: Into lv_agg_details(k)
5412: FROM msc_department_resources deptres,
5413: msc_resource_requirements resreq
5414: WHERE resreq.sr_instance_id= lv_instance_id(k)
5415: AND resreq.supply_id = lv_transaction_id(k)
5416: AND resreq.organization_id= lv_org_id(k)
5417: AND resreq.plan_id = lv_plan_id(k)

Line 5676: msc_resource_requirements res,

5672: 3,
5673: s.sr_instance_id,
5674: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5675: From msc_supplies s,
5676: msc_resource_requirements res,
5677: msc_apps_instances ins,
5678: msc_parameters param
5679: Where res.plan_id = s.plan_id
5680: AND res.sr_instance_id = s.sr_instance_id

Line 5781: msc_resource_requirements res,

5777: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
5778: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5779: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5780: From msc_supplies s,
5781: msc_resource_requirements res,
5782: msc_apps_instances ins,
5783: msc_parameters param,
5784: msc_department_resources mdr,
5785: msc_system_items msi

Line 5967: msc_resource_requirements res,

5963: res.orig_resource_seq_num,
5964: res.resource_seq_num,
5965: res.parent_seq_num
5966: From msc_supplies s,
5967: msc_resource_requirements res,
5968: msc_apps_instances ins,
5969: msc_parameters param
5970: Where res.plan_id = s.plan_id
5971: AND res.sr_instance_id = s.sr_instance_id

Line 6064: msc_resource_requirements resreq,

6060: 3,
6061: resreq.resource_id,
6062: 1
6063: FROM msc_trading_partners tp,
6064: msc_resource_requirements resreq,
6065: msc_resource_instance_reqs res_instreq, -- changed from design doc
6066: msc_dept_res_instances dep_res_inst,
6067: msc_supplies s,
6068: msc_apps_instances ins,

Line 6182: msc_resource_requirements resreq,

6178: , resreq.resource_id
6179: , 1
6180: FROM
6181: msc_trading_partners tp,
6182: msc_resource_requirements resreq,
6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,
6186: msc_apps_instances ins,

Line 6533: msc_resource_requirements resreq

6529: Begin
6530: SELECT 2
6531: Into lv_agg_details(k)
6532: FROM msc_department_resources deptres,
6533: msc_resource_requirements resreq
6534: WHERE resreq.sr_instance_id= lv_instance_id(k)
6535: AND resreq.supply_id = lv_transaction_id(k)
6536: AND resreq.organization_id= lv_org_id(k)
6537: AND resreq.plan_id = lv_plan_id(k)

Line 6882: msc_resource_requirements resreq,

6878: 1,
6879: resreq.operation_sequence_id, --Outbound changes for XML
6880: s.sr_instance_id
6881: FROM msc_trading_partners tp,
6882: msc_resource_requirements resreq,
6883: msc_parameters param,
6884: msc_system_items msi,
6885: msc_supplies s
6886: WHERE tp.sr_tp_id= msi.organization_id

Line 7044: msc_resource_requirements resreq,

7040: , resreq.parent_seq_num
7041: , resreq.orig_resource_seq_num
7042: , resreq.resource_seq_num
7043: FROM msc_trading_partners tp,
7044: msc_resource_requirements resreq,
7045: msc_parameters param,
7046: msc_system_items msi,
7047: msc_supplies s,
7048: msc_department_resources mdr

Line 7545: msc_resource_requirements resreq,

7541: resreq.department_id,
7542: resreq.resource_hours,
7543: resreq.parent_seq_num
7544: FROM msc_trading_partners tp,
7545: msc_resource_requirements resreq,
7546: msc_parameters param,
7547: msc_system_items msi,
7548: msc_supplies s,
7549: msc_department_resources mdr

Line 7659: msc_resource_requirements resreq,

7655: , 1 -- jguo
7656: , resreq.parent_seq_num
7657: FROM
7658: msc_trading_partners tp,
7659: msc_resource_requirements resreq,
7660: msc_resource_instance_reqs res_instreq,
7661: msc_dept_res_instances dep_res_inst,
7662: msc_supplies s
7663: WHERE

Line 7771: msc_resource_requirements resreq,

7767: ,1 -- jguo
7768: , resreq.parent_seq_num
7769: FROM
7770: msc_trading_partners tp,
7771: msc_resource_requirements resreq,
7772: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7773: msc_dept_res_instances dep_res_inst,
7774: msc_supplies s
7775: WHERE

Line 7869: msc_resource_requirements resreq,

7865: resreq.RESOURCE_ID,
7866: resreq.resource_seq_num
7867: FROM
7868: msc_trading_partners tp,
7869: msc_resource_requirements resreq,
7870: msc_supplies s,
7871: msc_resource_charges chg
7872: WHERE
7873: tp.sr_tp_id=s.organization_id

Line 8094: msc_resource_requirements resreq

8090: Begin
8091: SELECT 2
8092: Into lv_agg_details(k)
8093: FROM msc_department_resources deptres,
8094: msc_resource_requirements resreq
8095: WHERE resreq.sr_instance_id= lv_instance_id(k)
8096: AND resreq.supply_id = lv_transaction_id(k)
8097: AND resreq.organization_id= lv_org_id(k)
8098: AND resreq.plan_id = lv_plan_id(k)

Line 8407: msc_resource_requirements resreq,

8403: resreq.operation_sequence_id, --Outbound Changes for XML
8404: s.disposition_id
8405: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
8406: FROM msc_trading_partners tp,
8407: msc_resource_requirements resreq,
8408: msc_parameters param,
8409: msc_system_items msi,
8410: msc_supplies s
8411: WHERE tp.sr_tp_id= msi.organization_id

Line 8563: msc_resource_requirements resreq,

8559: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8560: , resreq.orig_resource_seq_num
8561: , resreq.resource_seq_num
8562: FROM msc_trading_partners tp,
8563: msc_resource_requirements resreq,
8564: msc_parameters param,
8565: msc_system_items msi,
8566: msc_supplies s
8567: WHERE tp.sr_tp_id= msi.organization_id

Line 8958: msc_resource_requirements resreq,

8954: , resreq.orig_resource_seq_num
8955: , resreq.resource_seq_num
8956: ,resreq.parent_seq_num
8957: FROM msc_trading_partners tp,
8958: msc_resource_requirements resreq,
8959: msc_parameters param,
8960: msc_system_items msi,
8961: msc_supplies s
8962: WHERE tp.sr_tp_id= msi.organization_id

Line 9066: msc_resource_requirements resreq,

9062: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
9063: , resreq.parent_seq_num
9064: FROM
9065: msc_trading_partners tp,
9066: msc_resource_requirements resreq,
9067: msc_resource_instance_reqs res_instreq,
9068: msc_dept_res_instances dep_res_inst,
9069: msc_supplies s
9070: WHERE

Line 9184: msc_resource_requirements resreq,

9180: , 1 -- jguo
9181: ,resreq.parent_seq_num
9182: FROM
9183: msc_trading_partners tp,
9184: msc_resource_requirements resreq,
9185: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
9186: msc_dept_res_instances dep_res_inst,
9187: msc_supplies s
9188: WHERE

Line 9288: msc_resource_requirements resreq,

9284: , resreq.RESOURCE_ID
9285: , resreq.resource_seq_num
9286: FROM
9287: msc_trading_partners tp,
9288: msc_resource_requirements resreq,
9289: msc_supplies s,
9290: msc_resource_charges chg
9291: WHERE
9292: tp.sr_tp_id=s.organization_id

Line 10889: msc_resource_requirements resreq

10885: Begin
10886: SELECT 2
10887: Into lv_agg_details(k)
10888: FROM msc_department_resources deptres,
10889: msc_resource_requirements resreq
10890: WHERE resreq.sr_instance_id= lv_instance_id(k)
10891: AND resreq.supply_id = lv_transaction_id(k)
10892: AND resreq.organization_id= lv_org_id(k)
10893: AND resreq.plan_id = lv_plan_id(k)

Line 11161: msc_resource_requirements resreq,

11157: resreq.operation_sequence_id, --Outbound Changes for XML
11158: s.disposition_id
11159: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
11160: FROM msc_trading_partners tp,
11161: msc_resource_requirements resreq,
11162: msc_parameters param,
11163: msc_system_items msi,
11164: msc_supplies s
11165: WHERE tp.sr_tp_id= msi.organization_id

Line 11312: msc_resource_requirements resreq,

11308: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11309: , resreq.orig_resource_seq_num
11310: , resreq.resource_seq_num
11311: FROM msc_trading_partners tp,
11312: msc_resource_requirements resreq,
11313: msc_parameters param,
11314: msc_system_items msi,
11315: msc_supplies s
11316: WHERE tp.sr_tp_id= msi.organization_id

Line 11660: msc_resource_requirements resreq,

11656: , resreq.orig_resource_seq_num
11657: , resreq.resource_seq_num
11658: ,resreq.parent_seq_num
11659: FROM msc_trading_partners tp,
11660: msc_resource_requirements resreq,
11661: msc_parameters param,
11662: msc_system_items msi,
11663: msc_supplies s
11664: WHERE tp.sr_tp_id= msi.organization_id

Line 11770: msc_resource_requirements resreq,

11766: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11767: , resreq.parent_seq_num
11768: FROM
11769: msc_trading_partners tp,
11770: msc_resource_requirements resreq,
11771: msc_resource_instance_reqs res_instreq,
11772: msc_dept_res_instances dep_res_inst,
11773: msc_supplies s
11774: WHERE

Line 11890: msc_resource_requirements resreq,

11886: , 1 -- jguo
11887: ,resreq.parent_seq_num
11888: FROM
11889: msc_trading_partners tp,
11890: msc_resource_requirements resreq,
11891: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
11892: msc_dept_res_instances dep_res_inst,
11893: msc_supplies s
11894: WHERE

Line 11996: msc_resource_requirements resreq,

11992: , resreq.RESOURCE_ID
11993: , resreq.resource_seq_num
11994: FROM
11995: msc_trading_partners tp,
11996: msc_resource_requirements resreq,
11997: msc_supplies s,
11998: msc_resource_charges chg
11999: WHERE
12000: tp.sr_tp_id=s.organization_id

Line 12218: msc_resource_requirements resreq

12214: Begin
12215: SELECT 2
12216: Into lv_agg_details(k)
12217: FROM msc_department_resources deptres,
12218: msc_resource_requirements resreq
12219: WHERE resreq.sr_instance_id= lv_instance_id(k)
12220: AND resreq.supply_id = lv_transaction_id(k)
12221: AND resreq.organization_id= lv_org_id(k)
12222: AND resreq.plan_id = lv_plan_id(k)

Line 12490: msc_resource_requirements resreq,

12486: resreq.operation_sequence_id, --Outbound Changes for XML
12487: s.disposition_id
12488: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
12489: FROM msc_trading_partners tp,
12490: msc_resource_requirements resreq,
12491: msc_parameters param,
12492: msc_system_items msi,
12493: msc_supplies s
12494: WHERE tp.sr_tp_id= msi.organization_id

Line 12641: msc_resource_requirements resreq,

12637: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12638: , resreq.orig_resource_seq_num
12639: , resreq.resource_seq_num
12640: FROM msc_trading_partners tp,
12641: msc_resource_requirements resreq,
12642: msc_parameters param,
12643: msc_system_items msi,
12644: msc_supplies s
12645: WHERE tp.sr_tp_id= msi.organization_id

Line 12991: msc_resource_requirements resreq,

12987: , resreq.orig_resource_seq_num
12988: , resreq.resource_seq_num
12989: ,resreq.parent_seq_num
12990: FROM msc_trading_partners tp,
12991: msc_resource_requirements resreq,
12992: msc_parameters param,
12993: msc_system_items msi,
12994: msc_supplies s
12995: WHERE tp.sr_tp_id= msi.organization_id

Line 13101: msc_resource_requirements resreq,

13097: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13098: , resreq.parent_seq_num
13099: FROM
13100: msc_trading_partners tp,
13101: msc_resource_requirements resreq,
13102: msc_resource_instance_reqs res_instreq,
13103: msc_dept_res_instances dep_res_inst,
13104: msc_supplies s
13105: WHERE

Line 13221: msc_resource_requirements resreq,

13217: , 1 -- jguo
13218: ,resreq.parent_seq_num
13219: FROM
13220: msc_trading_partners tp,
13221: msc_resource_requirements resreq,
13222: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
13223: msc_dept_res_instances dep_res_inst,
13224: msc_supplies s
13225: WHERE

Line 13327: msc_resource_requirements resreq,

13323: , resreq.RESOURCE_ID
13324: , resreq.resource_seq_num
13325: FROM
13326: msc_trading_partners tp,
13327: msc_resource_requirements resreq,
13328: msc_supplies s,
13329: msc_resource_charges chg
13330: WHERE
13331: tp.sr_tp_id=s.organization_id