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_PS_PLAN_PUB dependencies on MSC_PARAMETERS

Line 1086: msc_parameters param,

1082: s.sr_instance_id,
1083: s.schedule_priority,
1084: nvl(s.requested_completion_date, s.need_by_date)
1085: FROM msc_trading_partners tp,
1086: msc_parameters param,
1087: msc_item_id_lid item_lid,
1088: msc_supplies s
1089: WHERE tp.sr_tp_id= s.organization_id
1090: AND tp.sr_instance_id= s.sr_instance_id

Line 1158: msc_parameters param

1154: s.sr_instance_id
1155: From msc_supplies s,
1156: msc_operation_networks nwk,
1157: msc_apps_instances ins,
1158: msc_parameters param
1159: Where nwk.plan_id = -1
1160: AND nwk.sr_instance_id = s.sr_instance_id
1161: AND nwk.routing_sequence_id = s.routing_sequence_id
1162: AND nwk.transition_type = 1

Line 1216: msc_parameters param

1212: max(res.CUMMULATIVE_QUANTITY)
1213: From msc_supplies s,
1214: msc_resource_requirements res,
1215: msc_apps_instances ins,
1216: msc_parameters param
1217: Where res.plan_id = s.plan_id
1218: AND res.sr_instance_id = s.sr_instance_id
1219: AND s.transaction_id = res.supply_id
1220: AND res.parent_id = 2

Line 1333: msc_parameters param,

1329: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
1330: From msc_supplies s,
1331: msc_resource_requirements res,
1332: msc_apps_instances ins,
1333: msc_parameters param,
1334: msc_department_resources mdr,
1335: msc_system_items msi
1336: Where res.plan_id = s.plan_id
1337: AND res.sr_instance_id = s.sr_instance_id

Line 1423: msc_parameters param

1419: msc_system_items icomp,
1420: msc_system_items icomp1,
1421: msc_system_items icomp2,
1422: msc_apps_instances ins,
1423: msc_parameters param
1424: Where /* not exists (select 'x'
1425: from msc_exception_details excp
1426: where excp.plan_id = s.plan_id
1427: and excp.number1 = s.transaction_id

Line 1512: msc_parameters param

1508: res.parent_seq_num
1509: From msc_supplies s,
1510: msc_resource_requirements res,
1511: msc_apps_instances ins,
1512: msc_parameters param
1513: Where res.plan_id = s.plan_id
1514: AND res.sr_instance_id = s.sr_instance_id
1515: AND s.transaction_id = res.supply_id
1516: AND res.parent_id = 1

Line 1605: msc_parameters param

1601: msc_resource_requirements resreq,
1602: msc_resource_instance_reqs res_instreq,
1603: msc_supplies s,
1604: msc_apps_instances ins,
1605: msc_parameters param
1606: WHERE
1607: tp.sr_tp_id=s.organization_id
1608: AND tp.sr_instance_id= s.sr_instance_id
1609: AND tp.partner_type=3

Line 1712: msc_parameters param

1708: msc_resource_requirements resreq,
1709: msc_resource_instance_reqs res_instreq,
1710: msc_supplies s,
1711: msc_apps_instances ins,
1712: msc_parameters param
1713: WHERE
1714: tp.sr_tp_id=s.organization_id
1715: AND tp.sr_instance_id= s.sr_instance_id
1716: AND tp.partner_type=3

Line 1944: msc_parameters param,

1940: s.transaction_id, --Outbound Changes for XML
1941: s.schedule_priority,
1942: s.requested_completion_date
1943: FROM msc_trading_partners tp,
1944: msc_parameters param,
1945: msc_item_id_lid item_lid,
1946:
1947: msc_supplies s,
1948: msc_plan_organizations_v orgs

Line 2026: msc_parameters param

2022: s.sr_instance_id
2023: From msc_supplies s,
2024: msc_job_operation_networks nwk,
2025: msc_apps_instances ins,
2026: msc_parameters param
2027: Where nwk.plan_id = -1
2028: AND nwk.sr_instance_id = s.sr_instance_id
2029: AND nwk.transaction_id = s.transaction_id
2030: AND nwk.recommended = 'Y'

Line 2087: msc_parameters param

2083: max(res.CUMMULATIVE_QUANTITY)
2084: From msc_supplies s,
2085: msc_resource_requirements res,
2086: msc_apps_instances ins,
2087: msc_parameters param
2088: Where res.plan_id = s.plan_id
2089: AND res.sr_instance_id = s.sr_instance_id
2090: AND s.transaction_id = res.supply_id
2091: AND res.parent_id = 2

Line 2210: msc_parameters param,

2206: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
2207: From msc_supplies s,
2208: msc_resource_requirements res,
2209: msc_apps_instances ins,
2210: msc_parameters param,
2211: msc_department_resources mdr,
2212: msc_system_items msi
2213: Where res.plan_id = s.plan_id
2214: AND res.sr_instance_id = s.sr_instance_id

Line 2303: msc_parameters param

2299: msc_system_items icomp,
2300: msc_system_items icomp1,
2301: msc_system_items icomp2,
2302: msc_apps_instances ins,
2303: msc_parameters param
2304: Where /* not exists (select 'x'
2305: from msc_exception_details excp
2306: where excp.plan_id = s.plan_id
2307: and excp.number1 = s.transaction_id

Line 2395: msc_parameters param

2391: res.parent_seq_num
2392: From msc_supplies s,
2393: msc_resource_requirements res,
2394: msc_apps_instances ins,
2395: msc_parameters param
2396: Where res.plan_id = s.plan_id
2397: AND res.sr_instance_id = s.sr_instance_id
2398: AND s.transaction_id = res.supply_id
2399: AND res.parent_id = 1

Line 2490: msc_parameters param

2486: msc_resource_requirements resreq,
2487: msc_resource_instance_reqs res_instreq,
2488: msc_supplies s,
2489: msc_apps_instances ins,
2490: msc_parameters param
2491: WHERE
2492: tp.sr_tp_id=s.organization_id
2493: AND tp.sr_instance_id= s.sr_instance_id
2494: AND tp.partner_type=3

Line 2597: msc_parameters param

2593: msc_resource_requirements resreq,
2594: msc_resource_instance_reqs res_instreq,
2595: msc_supplies s,
2596: msc_apps_instances ins,
2597: msc_parameters param
2598: WHERE
2599: tp.sr_tp_id=s.organization_id
2600: AND tp.sr_instance_id= s.sr_instance_id
2601: AND tp.partner_type=3

Line 2883: msc_parameters param,

2879: s.sr_instance_id,
2880: s.schedule_priority,
2881: nvl(s.requested_completion_date, s.need_by_date)
2882: FROM msc_trading_partners tp,
2883: msc_parameters param,
2884: msc_item_id_lid item_lid,
2885: msc_supplies s
2886: WHERE tp.sr_tp_id= s.organization_id
2887: AND tp.sr_instance_id= s.sr_instance_id

Line 2975: msc_parameters param,

2971: resreq.operation_sequence_id, --Outbound changes for XML
2972: s.sr_instance_id
2973: FROM msc_trading_partners tp,
2974: msc_resource_requirements resreq,
2975: msc_parameters param,
2976: msc_supplies s
2977: WHERE tp.sr_tp_id= s.organization_id
2978: AND tp.sr_instance_id= s.sr_instance_id
2979: AND tp.partner_type=3

Line 3119: msc_parameters param,

3115: resreq.orig_resource_seq_num,
3116: resreq.resource_seq_num
3117: FROM msc_trading_partners tp,
3118: msc_resource_requirements resreq,
3119: msc_parameters param,
3120: msc_supplies s,
3121: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??
3122: WHERE tp.sr_tp_id= s.organization_id
3123: AND tp.sr_instance_id= s.sr_instance_id

Line 3225: msc_parameters param,

3221: s.sr_instance_id
3222: FROM msc_trading_partners tp,
3223: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3224: msc_demands md,
3225: msc_parameters param,
3226: msc_supplies s
3227: WHERE
3228: tp.sr_tp_id= icomp.organization_id
3229: AND tp.sr_instance_id= icomp.sr_instance_id

Line 3314: msc_parameters param,

3310: s.sr_instance_id
3311: FROM msc_trading_partners tp,
3312: msc_item_id_lid icomp,
3313: msc_supplies co,
3314: msc_parameters param,
3315: msc_supplies s
3316: WHERE tp.sr_tp_id = s.organization_id
3317: AND tp.sr_instance_id = s.sr_instance_id
3318: AND tp.partner_type = 3

Line 3522: msc_parameters param,

3518: resreq.resource_hours,
3519: resreq.parent_seq_num
3520: FROM msc_trading_partners tp,
3521: msc_resource_requirements resreq,
3522: msc_parameters param,
3523: msc_supplies s,
3524: msc_department_resources mdr
3525: WHERE tp.sr_tp_id= s.organization_id
3526: AND tp.sr_instance_id= s.sr_instance_id

Line 3973: msc_parameters param,

3969: s.transaction_id, --Outbound Changes for XML
3970: s.schedule_priority, --dsr
3971: s.requested_completion_date -- dsr
3972: FROM msc_trading_partners tp,
3973: msc_parameters param,
3974: msc_supplies s,
3975: msc_item_id_lid item_lid,
3976: msc_plan_organizations_v orgs,
3977: msc_demands md

Line 4113: msc_parameters param,

4109: s.transaction_id, --Outbound Changes for XML
4110: s.schedule_priority, --dsr
4111: s.requested_completion_date -- dsr
4112: FROM msc_trading_partners tp,
4113: msc_parameters param,
4114: msc_supplies s,
4115: msc_item_id_lid item_lid,
4116: msc_plan_organizations_v orgs
4117: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done

Line 4250: msc_parameters param,

4246: s.transaction_id, --Outbound Changes for XML
4247: s.schedule_priority, --dsr
4248: s.requested_completion_date -- dsr
4249: FROM msc_trading_partners tp,
4250: msc_parameters param,
4251: msc_supplies s,
4252: msc_item_id_lid item_lid,
4253: msc_plan_organizations_v orgs
4254: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done

Line 4353: msc_parameters param,

4349: resreq.operation_sequence_id, --Outbound Changes for XML
4350: s.disposition_id
4351: FROM msc_trading_partners tp,
4352: msc_resource_requirements resreq,
4353: msc_parameters param,
4354: msc_supplies s
4355: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct? -- ey, correct
4356: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct? -- ey, correct
4357: AND tp.partner_type=3

Line 4490: msc_parameters param,

4486: resreq.orig_resource_seq_num,
4487: resreq.resource_seq_num
4488: FROM msc_trading_partners tp,
4489: msc_resource_requirements resreq,
4490: msc_parameters param,
4491: msc_supplies s
4492: WHERE tp.sr_tp_id= s.organization_id
4493: AND tp.sr_instance_id= s.sr_instance_id
4494: AND tp.partner_type=3

Line 4688: msc_parameters param,

4684: -- ey, need to default it from uom_code for the item from msc_supplies s
4685: s.disposition_id
4686: FROM msc_trading_partners tp,
4687: msc_supplies co,
4688: msc_parameters param,
4689: msc_item_id_lid icomp,
4690: msc_supplies s
4691: WHERE tp.sr_tp_id = s.organization_id
4692: --MN: again, is this correct? -- ey, correct

Line 4977: msc_parameters param,

4973: resreq.resource_seq_num,
4974: resreq.parent_seq_num
4975: FROM msc_trading_partners tp,
4976: msc_resource_requirements resreq,
4977: msc_parameters param,
4978: msc_supplies s
4979: WHERE tp.sr_tp_id= s.organization_id
4980: AND tp.sr_instance_id=s.sr_instance_id
4981: AND tp.partner_type=3