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_SUPPLIES

Line 502: FROM MSC_SUPPLIES s

498: lv_wf:= SYS_YES;
499: BEGIN
500: SELECT load_type
501: INTO lv_wf_load_type
502: FROM MSC_SUPPLIES s
503: WHERE s.plan_id = arg_plan_id
504: AND s.transaction_id = arg_transaction_id
505: and s.release_status = 1;
506: EXCEPTION

Line 725: UPDATE MSC_SUPPLIES

721: arg_loaded_scheds > 0 OR
722: arg_loaded_reqs > 0 OR
723: arg_resched_reqs > 0 THEN
724:
725: UPDATE MSC_SUPPLIES
726: SET implement_demand_class = NULL,
727: implement_date = NULL,
728: implement_quantity = NULL,
729: implement_firm = NULL,

Line 877: FROM msc_supplies s,

873: INTO lv_transaction_id,
874: lv_instance_id,
875: lv_org_id,
876: lv_plan_id
877: FROM msc_supplies s,
878: msc_plan_organizations_v orgs,
879: msc_system_items msi,
880: msc_plans mp
881: WHERE mp.plan_id = arg_plan_id

Line 906: FROM msc_supplies s,

902: s.sr_instance_id,
903:
904: s.organization_id,
905: s.plan_id
906: FROM msc_supplies s,
907: msc_plan_organizations_v orgs
908: WHERE s.release_errors is NULL
909: AND nvl(s.cfm_routing_flag,0) = 3
910: AND s.implement_quantity > 0

Line 1062: msc_supplies s

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
1065: AND tp.partner_type=3
1066: AND param.organization_id = s.organization_id

Line 1129: From msc_supplies s,

1125: nwk.from_op_seq_num,
1126: nwk.to_op_seq_num,
1127: 3,
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

Line 1187: From msc_supplies s,

1183: max(res.END_DATE),
1184: 3,
1185: s.sr_instance_id,
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

Line 1304: From msc_supplies s,

1300: res.RESOURCE_HOURS
1301: ),
1302:
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,

Line 1391: From msc_supplies s,

1387: md.USING_REQUIREMENT_QUANTITY,
1388: md.USING_REQUIREMENT_QUANTITY,
1389: 3,
1390: s.sr_instance_id
1391: From msc_supplies s,
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,

Line 1483: From msc_supplies s,

1479: s.sr_instance_id,
1480: res.orig_resource_seq_num,
1481: res.resource_seq_num,
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

Line 1577: msc_supplies s,

1573: FROM
1574: msc_trading_partners tp,
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

Line 1684: msc_supplies s,

1680: FROM
1681: msc_trading_partners tp,
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

Line 1770: msc_supplies s,

1766: lv_instance_id,
1767: lv_org_id,
1768: lv_plan_id
1769: FROM msc_plans mp,
1770: msc_supplies s,
1771: msc_plan_organizations_v orgs
1772: WHERE mp.plan_id = arg_plan_id
1773: AND s.release_errors is NULL
1774: AND s.implement_quantity > 0

Line 1920: msc_supplies s,

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
1922: WHERE tp.sr_tp_id= s.organization_id
1923: AND tp.sr_instance_id= s.sr_instance_id
1924: AND tp.partner_type=3

Line 1996: From msc_supplies s,

1992: decode(nwk.from_op_seq_num, 50000 ,null,nwk.from_op_seq_num),
1993: nwk.to_op_seq_num,
1994: 3,
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

Line 2057: From msc_supplies s,

2053: max(res.END_DATE),
2054: 3,
2055: s.sr_instance_id,
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

Line 2180: From msc_supplies s,

2176: ),
2177: res.RESOURCE_HOURS
2178: ),
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,

Line 2270: From msc_supplies s,

2266: md.USING_REQUIREMENT_QUANTITY,
2267: md.USING_REQUIREMENT_QUANTITY,
2268: 3,
2269: s.sr_instance_id
2270: From msc_supplies s,
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,

Line 2365: From msc_supplies s,

2361: s.sr_instance_id,
2362: res.orig_resource_seq_num,
2363: res.resource_seq_num,
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

Line 2461: msc_supplies s,

2457: 1
2458: FROM msc_trading_partners tp,
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

Line 2568: msc_supplies s,

2564: FROM
2565: msc_trading_partners tp,
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

Line 2674: FROM msc_supplies s,

2670: lv_instance_id,
2671: lv_org_id,
2672: lv_plan_id,
2673: lv_round_primary_item
2674: FROM msc_supplies s,
2675: msc_plan_organizations_v orgs,
2676: msc_system_items msi, -- REMOVE
2677: msc_plans mp
2678: WHERE mp.plan_id = arg_plan_id

Line 2703: FROM msc_supplies s,

2699: s.sr_instance_id,
2700: s.organization_id,
2701: s.plan_id,
2702: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
2703: FROM msc_supplies s,
2704: msc_plan_organizations_v orgs
2705: WHERE s.release_errors is NULL
2706: AND s.implement_quantity > 0
2707: AND s.organization_id = orgs.planned_organization

Line 2858: msc_supplies s

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
2861: AND tp.partner_type=3
2862: AND param.organization_id = s.organization_id

Line 2949: msc_supplies s

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
2953: AND resreq.sr_instance_id= s.sr_instance_id

Line 3093: msc_supplies s,

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
3097: AND tp.partner_type=3

Line 3199: msc_supplies s

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
3203: AND tp.partner_type=3

Line 3286: msc_supplies co,

3282: s.implement_uom_code, -- bugbug MN: again is this correct?
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

Line 3288: msc_supplies s

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
3292: AND icomp.inventory_item_id = co.inventory_item_id

Line 3380: msc_supplies s

3376: msc_component_substitutes bsub,
3377: /* msc_bom_components bcomp, */
3378: msc_item_id_lid icomp,
3379: msc_demands md,
3380: msc_supplies s
3381:
3382: WHERE tp.sr_tp_id= s.organization_id
3383: AND tp.sr_instance_id= s.sr_instance_id
3384: AND tp.partner_type=3

Line 3496: msc_supplies s,

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
3500: AND tp.partner_type=3

Line 3597: msc_supplies s

3593: msc_trading_partners tp,
3594: msc_resource_requirements resreq,
3595: msc_resource_instance_reqs res_instreq,
3596: msc_dept_res_instances dep_res_inst,
3597: msc_supplies s
3598: WHERE
3599: tp.sr_tp_id=s.organization_id
3600: AND tp.sr_instance_id= s.sr_instance_id
3601: AND tp.partner_type=3

Line 3701: msc_supplies s

3697: FROM
3698: msc_trading_partners tp,
3699: msc_resource_requirements resreq,
3700: msc_resource_instance_reqs res_instreq,
3701: msc_supplies s
3702: WHERE
3703: tp.sr_tp_id=s.organization_id
3704: AND tp.sr_instance_id= s.sr_instance_id
3705: AND tp.partner_type=3

Line 3778: FROM msc_supplies s,

3774: INTO lv_transaction_id,
3775: lv_instance_id,
3776: lv_org_id,
3777: lv_plan_id
3778: FROM msc_supplies s,
3779: msc_plan_organizations_v orgs,
3780: msc_plans mp
3781: WHERE s.release_errors is NULL
3782: AND s.implement_quantity > 0

Line 3946: msc_supplies s,

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
3950: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added

Line 4048: msc_supplies s

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
4052: AND resreq.sr_instance_id= s.sr_instance_id

Line 4184: msc_supplies s

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
4188: AND resreq.sr_instance_id= s.sr_instance_id

Line 4285: msc_supplies s

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
4288: AND tp.sr_instance_id= s.sr_instance_id -- ey, s.sr_instance_id
4289: AND tp.partner_type=3

Line 4379: -- ey, need to default it from uom_code for the item from msc_supplies s

4375: 1,
4376: TO_CHAR(NULL),
4377: s.sr_instance_id,
4378: s.implement_uom_code, -- bugbug MN: again, is this correct?
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,

Line 4382: msc_supplies co,

4378: s.implement_uom_code, -- bugbug MN: again, is this correct?
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

Line 4385: msc_supplies s

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
4388: AND tp.sr_instance_id = s.sr_instance_id --MN: again, is this correct? -- ey, correct
4389: AND tp.partner_type = 3

Line 4478: msc_supplies s

4474: msc_component_substitutes bsub,
4475: /* msc_bom_components bcomp, */
4476: msc_item_id_lid icomp,
4477: msc_demands md,
4478: msc_supplies s
4479:
4480: WHERE tp.sr_tp_id= s.organization_id
4481: AND tp.sr_instance_id= s.sr_instance_id
4482: AND tp.partner_type=3

Line 4594: msc_supplies s

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
4598: AND resreq.sr_instance_id= s.sr_instance_id

Line 4689: msc_supplies s

4685: FROM
4686: msc_trading_partners tp,
4687: msc_resource_requirements resreq,
4688: msc_resource_instance_reqs res_instreq,
4689: msc_supplies s
4690: WHERE
4691: tp.sr_tp_id=s.organization_id
4692: AND tp.sr_instance_id= s.sr_instance_id
4693: AND tp.partner_type=3

Line 4788: msc_supplies s

4784: FROM
4785: msc_trading_partners tp,
4786: msc_resource_requirements resreq,
4787: msc_resource_instance_reqs res_instreq,
4788: msc_supplies s
4789: WHERE
4790: tp.sr_tp_id=s.organization_id
4791: AND tp.sr_instance_id= s.sr_instance_id
4792: AND tp.partner_type=3