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 1060: msc_parameters param,

1056: s.sr_instance_id,
1057: s.schedule_priority,
1058: nvl(s.requested_completion_date, s.need_by_date)
1059: FROM msc_trading_partners tp,
1060: msc_parameters param,
1061: msc_item_id_lid item_lid,
1062: msc_supplies s
1063: WHERE tp.sr_tp_id= s.organization_id
1064: AND tp.sr_instance_id= s.sr_instance_id

Line 1132: msc_parameters param

1128: s.sr_instance_id
1129: From msc_supplies s,
1130: msc_operation_networks nwk,
1131: msc_apps_instances ins,
1132: msc_parameters param
1133: Where nwk.plan_id = -1
1134: AND nwk.sr_instance_id = s.sr_instance_id
1135: AND nwk.routing_sequence_id = s.routing_sequence_id
1136: AND nwk.transition_type = 1

Line 1190: msc_parameters param

1186: max(res.CUMMULATIVE_QUANTITY)
1187: From msc_supplies s,
1188: msc_resource_requirements res,
1189: msc_apps_instances ins,
1190: msc_parameters param
1191: Where res.plan_id = s.plan_id
1192: AND res.sr_instance_id = s.sr_instance_id
1193: AND s.transaction_id = res.supply_id
1194: AND res.parent_id = 2

Line 1307: msc_parameters param,

1303: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
1304: From msc_supplies s,
1305: msc_resource_requirements res,
1306: msc_apps_instances ins,
1307: msc_parameters param,
1308: msc_department_resources mdr,
1309: msc_system_items msi
1310: Where res.plan_id = s.plan_id
1311: AND res.sr_instance_id = s.sr_instance_id

Line 1397: msc_parameters param

1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,
1397: msc_parameters param
1398: Where /* not exists (select 'x'
1399: from msc_exception_details excp
1400: where excp.plan_id = s.plan_id
1401: and excp.number1 = s.transaction_id

Line 1486: msc_parameters param

1482: res.parent_seq_num
1483: From msc_supplies s,
1484: msc_resource_requirements res,
1485: msc_apps_instances ins,
1486: msc_parameters param
1487: Where res.plan_id = s.plan_id
1488: AND res.sr_instance_id = s.sr_instance_id
1489: AND s.transaction_id = res.supply_id
1490: AND res.parent_id = 1

Line 1579: msc_parameters param

1575: msc_resource_requirements resreq,
1576: msc_resource_instance_reqs res_instreq,
1577: msc_supplies s,
1578: msc_apps_instances ins,
1579: msc_parameters param
1580: WHERE
1581: tp.sr_tp_id=s.organization_id
1582: AND tp.sr_instance_id= s.sr_instance_id
1583: AND tp.partner_type=3

Line 1686: msc_parameters param

1682: msc_resource_requirements resreq,
1683: msc_resource_instance_reqs res_instreq,
1684: msc_supplies s,
1685: msc_apps_instances ins,
1686: msc_parameters param
1687: WHERE
1688: tp.sr_tp_id=s.organization_id
1689: AND tp.sr_instance_id= s.sr_instance_id
1690: AND tp.partner_type=3

Line 1917: msc_parameters param,

1913: s.transaction_id, --Outbound Changes for XML
1914: s.schedule_priority,
1915: s.requested_completion_date
1916: FROM msc_trading_partners tp,
1917: msc_parameters param,
1918: msc_item_id_lid item_lid,
1919:
1920: msc_supplies s,
1921: msc_plan_organizations_v orgs

Line 1999: msc_parameters param

1995: s.sr_instance_id
1996: From msc_supplies s,
1997: msc_job_operation_networks nwk,
1998: msc_apps_instances ins,
1999: msc_parameters param
2000: Where nwk.plan_id = -1
2001: AND nwk.sr_instance_id = s.sr_instance_id
2002: AND nwk.transaction_id = s.transaction_id
2003: AND nwk.recommended = 'Y'

Line 2060: msc_parameters param

2056: max(res.CUMMULATIVE_QUANTITY)
2057: From msc_supplies s,
2058: msc_resource_requirements res,
2059: msc_apps_instances ins,
2060: msc_parameters param
2061: Where res.plan_id = s.plan_id
2062: AND res.sr_instance_id = s.sr_instance_id
2063: AND s.transaction_id = res.supply_id
2064: AND res.parent_id = 2

Line 2183: msc_parameters param,

2179: decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
2180: From msc_supplies s,
2181: msc_resource_requirements res,
2182: msc_apps_instances ins,
2183: msc_parameters param,
2184: msc_department_resources mdr,
2185: msc_system_items msi
2186: Where res.plan_id = s.plan_id
2187: AND res.sr_instance_id = s.sr_instance_id

Line 2276: msc_parameters param

2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,
2276: msc_parameters param
2277: Where /* not exists (select 'x'
2278: from msc_exception_details excp
2279: where excp.plan_id = s.plan_id
2280: and excp.number1 = s.transaction_id

Line 2368: msc_parameters param

2364: res.parent_seq_num
2365: From msc_supplies s,
2366: msc_resource_requirements res,
2367: msc_apps_instances ins,
2368: msc_parameters param
2369: Where res.plan_id = s.plan_id
2370: AND res.sr_instance_id = s.sr_instance_id
2371: AND s.transaction_id = res.supply_id
2372: AND res.parent_id = 1

Line 2463: msc_parameters param

2459: msc_resource_requirements resreq,
2460: msc_resource_instance_reqs res_instreq,
2461: msc_supplies s,
2462: msc_apps_instances ins,
2463: msc_parameters param
2464: WHERE
2465: tp.sr_tp_id=s.organization_id
2466: AND tp.sr_instance_id= s.sr_instance_id
2467: AND tp.partner_type=3

Line 2570: msc_parameters param

2566: msc_resource_requirements resreq,
2567: msc_resource_instance_reqs res_instreq,
2568: msc_supplies s,
2569: msc_apps_instances ins,
2570: msc_parameters param
2571: WHERE
2572: tp.sr_tp_id=s.organization_id
2573: AND tp.sr_instance_id= s.sr_instance_id
2574: AND tp.partner_type=3

Line 2856: msc_parameters param,

2852: s.sr_instance_id,
2853: s.schedule_priority,
2854: nvl(s.requested_completion_date, s.need_by_date)
2855: FROM msc_trading_partners tp,
2856: msc_parameters param,
2857: msc_item_id_lid item_lid,
2858: msc_supplies s
2859: WHERE tp.sr_tp_id= s.organization_id
2860: AND tp.sr_instance_id= s.sr_instance_id

Line 2948: msc_parameters param,

2944: resreq.operation_sequence_id, --Outbound changes for XML
2945: s.sr_instance_id
2946: FROM msc_trading_partners tp,
2947: msc_resource_requirements resreq,
2948: msc_parameters param,
2949: msc_supplies s
2950: WHERE tp.sr_tp_id= s.organization_id
2951: AND tp.sr_instance_id= s.sr_instance_id
2952: AND tp.partner_type=3

Line 3092: msc_parameters param,

3088: resreq.orig_resource_seq_num,
3089: resreq.resource_seq_num
3090: FROM msc_trading_partners tp,
3091: msc_resource_requirements resreq,
3092: msc_parameters param,
3093: msc_supplies s,
3094: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??
3095: WHERE tp.sr_tp_id= s.organization_id
3096: AND tp.sr_instance_id= s.sr_instance_id

Line 3198: msc_parameters param,

3194: s.sr_instance_id
3195: FROM msc_trading_partners tp,
3196: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3197: msc_demands md,
3198: msc_parameters param,
3199: msc_supplies s
3200: WHERE
3201: tp.sr_tp_id= icomp.organization_id
3202: AND tp.sr_instance_id= icomp.sr_instance_id

Line 3287: msc_parameters param,

3283: s.sr_instance_id
3284: FROM msc_trading_partners tp,
3285: msc_item_id_lid icomp,
3286: msc_supplies co,
3287: msc_parameters param,
3288: msc_supplies s
3289: WHERE tp.sr_tp_id = s.organization_id
3290: AND tp.sr_instance_id = s.sr_instance_id
3291: AND tp.partner_type = 3

Line 3495: msc_parameters param,

3491: resreq.resource_hours,
3492: resreq.parent_seq_num
3493: FROM msc_trading_partners tp,
3494: msc_resource_requirements resreq,
3495: msc_parameters param,
3496: msc_supplies s,
3497: msc_department_resources mdr
3498: WHERE tp.sr_tp_id= s.organization_id
3499: AND tp.sr_instance_id= s.sr_instance_id

Line 3945: msc_parameters param,

3941: s.transaction_id, --Outbound Changes for XML
3942: s.schedule_priority, --dsr
3943: s.requested_completion_date -- dsr
3944: FROM msc_trading_partners tp,
3945: msc_parameters param,
3946: msc_supplies s,
3947: msc_item_id_lid item_lid,
3948: msc_plan_organizations_v orgs
3949: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done

Line 4047: msc_parameters param,

4043: resreq.operation_sequence_id, --Outbound Changes for XML
4044: s.disposition_id
4045: FROM msc_trading_partners tp,
4046: msc_resource_requirements resreq,
4047: msc_parameters param,
4048: msc_supplies s
4049: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct? -- ey, correct
4050: AND tp.sr_instance_id= s.sr_instance_id --MN: again, is this correct? -- ey, correct
4051: AND tp.partner_type=3

Line 4183: msc_parameters param,

4179: resreq.orig_resource_seq_num,
4180: resreq.resource_seq_num
4181: FROM msc_trading_partners tp,
4182: msc_resource_requirements resreq,
4183: msc_parameters param,
4184: msc_supplies s
4185: WHERE tp.sr_tp_id= s.organization_id
4186: AND tp.sr_instance_id= s.sr_instance_id
4187: AND tp.partner_type=3

Line 4283: msc_parameters param,

4279: s.implement_uom_code, -- bugbug MN: again, is this correct?
4280: s.disposition_id
4281: FROM msc_trading_partners tp,
4282: msc_demands md,
4283: msc_parameters param,
4284: msc_system_items msi,
4285: msc_supplies s
4286: -- bugbug Is this join correct?
4287: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id

Line 4383: msc_parameters param,

4379: -- ey, need to default it from uom_code for the item from msc_supplies s
4380: s.disposition_id
4381: FROM msc_trading_partners tp,
4382: msc_supplies co,
4383: msc_parameters param,
4384: msc_item_id_lid icomp,
4385: msc_supplies s
4386: WHERE tp.sr_tp_id = s.organization_id
4387: --MN: again, is this correct? -- ey, correct

Line 4593: msc_parameters param,

4589: resreq.resource_seq_num,
4590: resreq.parent_seq_num
4591: FROM msc_trading_partners tp,
4592: msc_resource_requirements resreq,
4593: msc_parameters param,
4594: msc_supplies s
4595: WHERE tp.sr_tp_id= s.organization_id
4596: AND tp.sr_instance_id=s.sr_instance_id
4597: AND tp.partner_type=3