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_DEPARTMENT_RESOURCES

Line 940: FROM msc_department_resources deptres,

936: Loop
937: Begin
938: SELECT 2
939: Into lv_agg_details(k)
940: FROM msc_department_resources deptres,
941: msc_resource_requirements resreq
942: WHERE resreq.sr_instance_id= lv_instance_id(k)
943: AND resreq.supply_id = lv_transaction_id(k)
944: AND resreq.organization_id= lv_org_id(k)

Line 1308: msc_department_resources mdr,

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
1312: AND s.transaction_id = res.supply_id

Line 1795: FROM msc_department_resources deptres,

1791: Loop
1792: Begin
1793: SELECT 2
1794: Into lv_agg_details(k)
1795: FROM msc_department_resources deptres,
1796: msc_resource_requirements resreq
1797: WHERE resreq.sr_instance_id= lv_instance_id(k)
1798: AND resreq.supply_id = lv_transaction_id(k)
1799: AND resreq.organization_id= lv_org_id(k)

Line 2184: msc_department_resources mdr,

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
2188: AND s.transaction_id = res.supply_id

Line 2735: FROM msc_department_resources deptres,

2731: Loop
2732: Begin
2733: SELECT 2
2734: Into lv_agg_details(k)
2735: FROM msc_department_resources deptres,
2736: msc_resource_requirements resreq
2737: WHERE resreq.sr_instance_id= lv_instance_id(k)
2738: AND resreq.supply_id = lv_transaction_id(k)
2739: AND resreq.organization_id= lv_org_id(k)

Line 3094: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??

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

Line 3497: msc_department_resources mdr

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

Line 3825: FROM msc_department_resources deptres,

3821: Loop
3822: Begin
3823: SELECT 2
3824: Into lv_agg_details(k)
3825: FROM msc_department_resources deptres,
3826: msc_resource_requirements resreq
3827: WHERE resreq.sr_instance_id= lv_instance_id(k)
3828: AND resreq.supply_id = lv_transaction_id(k)
3829: AND resreq.organization_id= lv_org_id(k)