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_PARAMETERS

Line 4604: msc_parameters param,

4600: -- dsr: 2 new columns
4601: , s.schedule_priority
4602: , nvl(s.requested_completion_date, s.need_by_date)
4603: FROM msc_trading_partners tp,
4604: msc_parameters param,
4605: msc_system_items msi,
4606: msc_process_effectivity mpe,
4607: msc_supplies s
4608: WHERE tp.sr_tp_id= msi.organization_id

Line 4680: msc_parameters param

4676: s.sr_instance_id
4677: From msc_supplies s,
4678: msc_operation_networks nwk,
4679: msc_apps_instances ins,
4680: msc_parameters param
4681: Where nwk.plan_id = s.plan_id
4682: AND nwk.sr_instance_id = s.sr_instance_id
4683: AND nwk.routing_sequence_id = s.routing_sequence_id
4684: AND nwk.transition_type = 1

Line 4738: msc_parameters param

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
4741: AND s.transaction_id = res.supply_id
4742: AND res.parent_id = 2

Line 4838: msc_parameters param,

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
4841: Where res.plan_id = s.plan_id
4842: AND res.sr_instance_id = s.sr_instance_id

Line 4927: msc_parameters param

4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,
4927: msc_parameters param
4928: Where /* not exists (select 'x'
4929: from msc_exception_details excp
4930: where excp.plan_id = s.plan_id
4931: and excp.number1 = s.transaction_id

Line 5021: msc_parameters param

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
5024: AND s.transaction_id = res.supply_id
5025: AND res.parent_id = 1

Line 5117: msc_parameters param

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,
5117: msc_parameters param
5118: WHERE
5119: tp.sr_tp_id=s.organization_id
5120: AND tp.sr_instance_id= s.sr_instance_id
5121: AND tp.partner_type=3

Line 5236: msc_parameters param

5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,
5235: msc_apps_instances ins,
5236: msc_parameters param
5237: WHERE
5238: tp.sr_tp_id=s.organization_id
5239: AND tp.sr_instance_id= s.sr_instance_id
5240: AND tp.partner_type=3

Line 5536: msc_parameters param,

5532: -- dsr: added 2 new columns
5533: , s.schedule_priority
5534: , s.requested_completion_date
5535: FROM msc_trading_partners tp,
5536: msc_parameters param,
5537: msc_system_items msi,
5538: msc_supplies s,
5539: msc_plan_organizations_v orgs
5540: WHERE tp.sr_tp_id= msi.organization_id

Line 5618: msc_parameters param

5614: s.sr_instance_id
5615: From msc_supplies s,
5616: msc_job_operation_networks nwk,
5617: msc_apps_instances ins,
5618: msc_parameters param
5619: Where nwk.plan_id = s.plan_id
5620: AND nwk.sr_instance_id = s.sr_instance_id
5621: AND nwk.transaction_id = s.transaction_id
5622: AND nwk.recommended = 'Y'

Line 5678: msc_parameters param

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
5681: AND s.transaction_id = res.supply_id
5682: AND res.parent_id = 2

Line 5783: msc_parameters param,

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
5786: Where res.plan_id = s.plan_id
5787: AND res.sr_instance_id = s.sr_instance_id

Line 5874: msc_parameters param

5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,
5874: msc_parameters param
5875: Where /* not exists (select 'x'
5876: from msc_exception_details excp
5877: where excp.plan_id = s.plan_id
5878: and excp.number1 = s.transaction_id

Line 5969: msc_parameters param

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
5972: AND s.transaction_id = res.supply_id
5973: AND res.parent_id = 1

Line 6069: msc_parameters param

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,
6069: msc_parameters param
6070: WHERE
6071: tp.sr_tp_id=s.organization_id
6072: AND tp.sr_instance_id= s.sr_instance_id
6073: AND tp.partner_type=3

Line 6187: msc_parameters param

6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,
6186: msc_apps_instances ins,
6187: msc_parameters param
6188: WHERE
6189: tp.sr_tp_id=s.organization_id
6190: AND tp.sr_instance_id= s.sr_instance_id
6191: AND tp.partner_type=3

Line 6744: msc_parameters param,

6740: -- dsr
6741: , s.schedule_priority
6742: , nvl(s.requested_completion_date, s.need_by_date)
6743: FROM msc_trading_partners tp,
6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,
6748: msc_boms mb

Line 6883: msc_parameters param,

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
6887: AND tp.sr_instance_id= msi.sr_instance_id

Line 7045: msc_parameters param,

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
7049: WHERE tp.sr_tp_id= msi.organization_id

Line 7171: msc_parameters param,

7167: s.sr_instance_id
7168: FROM msc_trading_partners tp,
7169: msc_system_items icomp,
7170: msc_demands md,
7171: msc_parameters param,
7172: msc_system_items msi,
7173: msc_supplies s
7174: WHERE /*
7175: ( md.SUBST_ITEM_FLAG <> 1

Line 7281: msc_parameters param,

7277: s.sr_instance_id
7278: FROM msc_trading_partners tp,
7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,
7283: msc_supplies s
7284: WHERE /* not exists (select 'x'
7285: from msc_exception_details excp

Line 7401: msc_parameters param,

7397: /* msc_bom_components bcomp, */
7398: msc_boms bom,
7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,
7402: msc_system_items msi,
7403: msc_supplies s
7404: WHERE tp.sr_tp_id= msi.organization_id
7405: AND tp.sr_instance_id= msi.sr_instance_id

Line 7546: msc_parameters param,

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
7550: WHERE tp.sr_tp_id= msi.organization_id

Line 8272: msc_parameters param,

8268: s.transaction_id --Outbound Changes for XML
8269: , s.schedule_priority -- dsr
8270: , s.requested_completion_date -- dsr
8271: FROM msc_trading_partners tp,
8272: msc_parameters param,
8273: msc_system_items msi,
8274: msc_supplies s,
8275: msc_plan_organizations_v orgs,
8276: msc_boms mb

Line 8408: msc_parameters param,

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
8412: AND tp.sr_instance_id= msi.sr_instance_id

Line 8564: msc_parameters param,

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
8568: AND tp.sr_instance_id= msi.sr_instance_id

Line 8691: msc_parameters param,

8687: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8688: FROM msc_trading_partners tp,
8689: msc_system_items icomp,
8690: msc_demands md,
8691: msc_parameters param,
8692: msc_system_items msi,
8693: msc_supplies s
8694: WHERE /*
8695: ( md.SUBST_ITEM_FLAG <> 1

Line 8825: msc_parameters param,

8821: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8822: FROM msc_trading_partners tp,
8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,
8827: msc_supplies s
8828: WHERE /*not exists (select 'x'
8829: from msc_exception_details excp

Line 8959: msc_parameters param,

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
8963: AND tp.sr_instance_id= msi.sr_instance_id

Line 9409: msc_parameters param,

9405: s.transaction_id,
9406: nvl(s.implement_uom_code,msi.uom_code),
9407: s.sr_instance_id
9408: FROM msc_trading_partners tp,
9409: msc_parameters param,
9410: msc_system_items msi,
9411: msc_process_effectivity mpe,
9412: msc_supplies s,
9413: msc_plan_organizations_v orgs

Line 10652: msc_parameters param,

10648: s.sr_instance_id
10649: , s.schedule_priority
10650: , nvl(s.requested_completion_date, s.need_by_date)
10651: FROM msc_trading_partners tp,
10652: msc_parameters param,
10653: msc_system_items msi,
10654: msc_process_effectivity mpe,
10655: msc_supplies s
10656: WHERE tp.sr_tp_id= msi.organization_id

Line 11043: msc_parameters param,

11039: s.transaction_id
11040: , s.schedule_priority
11041: , s.requested_completion_date
11042: FROM msc_trading_partners tp,
11043: msc_parameters param,
11044: msc_system_items msi,
11045: msc_supplies s,
11046: msc_plan_organizations_v orgs
11047: WHERE tp.sr_tp_id= msi.organization_id

Line 11162: msc_parameters param,

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
11166: AND tp.sr_instance_id= msi.sr_instance_id

Line 11313: msc_parameters param,

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
11317: AND tp.sr_instance_id= msi.sr_instance_id

Line 11418: msc_parameters param,

11414: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11415: FROM msc_trading_partners tp,
11416: msc_system_items icomp,
11417: msc_demands md,
11418: msc_parameters param,
11419: msc_system_items msi,
11420: msc_supplies s
11421: WHERE /*
11422: ( md.SUBST_ITEM_FLAG <> 1

Line 11534: msc_parameters param,

11530: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11531: FROM msc_trading_partners tp,
11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,
11536: msc_supplies s
11537: WHERE /*not exists (select 'x'
11538: from msc_exception_details excp

Line 11661: msc_parameters param,

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
11665: AND tp.sr_instance_id= msi.sr_instance_id

Line 12372: msc_parameters param,

12368: s.transaction_id
12369: , s.schedule_priority
12370: , s.requested_completion_date
12371: FROM msc_trading_partners tp,
12372: msc_parameters param,
12373: msc_system_items msi,
12374: msc_supplies s,
12375: msc_plan_organizations_v orgs
12376: WHERE tp.sr_tp_id= msi.organization_id

Line 12491: msc_parameters param,

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
12495: AND tp.sr_instance_id= msi.sr_instance_id

Line 12642: msc_parameters param,

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
12646: AND tp.sr_instance_id= msi.sr_instance_id

Line 12748: msc_parameters param,

12744: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12745: FROM msc_trading_partners tp,
12746: msc_system_items icomp,
12747: msc_demands md,
12748: msc_parameters param,
12749: msc_system_items msi,
12750: msc_supplies s
12751: WHERE /*
12752: ( md.SUBST_ITEM_FLAG <> 1

Line 12865: msc_parameters param,

12861: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12862: FROM msc_trading_partners tp,
12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,
12867: msc_supplies s
12868: WHERE /*not exists (select 'x'
12869: from msc_exception_details excp

Line 12992: msc_parameters param,

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
12996: AND tp.sr_instance_id= msi.sr_instance_id

Line 13432: msc_parameters param,

13428: FROM msc_trading_partners tp,
13429: msc_system_items icompold,
13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,
13434: msc_supplies ms,
13435: msc_exception_details med
13436: WHERE med.exception_type = WORK_ORDER_SUB_COMPONENT