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_DEPARTMENT_RESOURCES

Line 4484: FROM msc_department_resources deptres,

4480: Loop
4481: Begin
4482: SELECT 2
4483: Into lv_agg_details(k)
4484: FROM msc_department_resources deptres,
4485: msc_resource_requirements resreq
4486: WHERE resreq.sr_instance_id= lv_instance_id(k)
4487: AND resreq.supply_id = lv_transaction_id(k)
4488: AND resreq.organization_id= lv_org_id(k)

Line 4839: msc_department_resources mdr,

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

Line 5412: FROM msc_department_resources deptres,

5408: Loop
5409: Begin
5410: SELECT 2
5411: Into lv_agg_details(k)
5412: FROM msc_department_resources deptres,
5413: msc_resource_requirements resreq
5414: WHERE resreq.sr_instance_id= lv_instance_id(k)
5415: AND resreq.supply_id = lv_transaction_id(k)
5416: AND resreq.organization_id= lv_org_id(k)

Line 5784: msc_department_resources mdr,

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

Line 6532: FROM msc_department_resources deptres,

6528: Loop
6529: Begin
6530: SELECT 2
6531: Into lv_agg_details(k)
6532: FROM msc_department_resources deptres,
6533: msc_resource_requirements resreq
6534: WHERE resreq.sr_instance_id= lv_instance_id(k)
6535: AND resreq.supply_id = lv_transaction_id(k)
6536: AND resreq.organization_id= lv_org_id(k)

Line 7048: msc_department_resources mdr

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
7050: AND tp.sr_instance_id= msi.sr_instance_id
7051: AND tp.partner_type=3
7052: AND resreq.sr_instance_id= s.sr_instance_id

Line 7549: msc_department_resources mdr

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
7551: AND tp.sr_instance_id= msi.sr_instance_id
7552: AND tp.partner_type=3
7553: AND resreq.sr_instance_id= s.sr_instance_id

Line 8093: FROM msc_department_resources deptres,

8089: Loop
8090: Begin
8091: SELECT 2
8092: Into lv_agg_details(k)
8093: FROM msc_department_resources deptres,
8094: msc_resource_requirements resreq
8095: WHERE resreq.sr_instance_id= lv_instance_id(k)
8096: AND resreq.supply_id = lv_transaction_id(k)
8097: AND resreq.organization_id= lv_org_id(k)

Line 10888: FROM msc_department_resources deptres,

10884: Loop
10885: Begin
10886: SELECT 2
10887: Into lv_agg_details(k)
10888: FROM msc_department_resources deptres,
10889: msc_resource_requirements resreq
10890: WHERE resreq.sr_instance_id= lv_instance_id(k)
10891: AND resreq.supply_id = lv_transaction_id(k)
10892: AND resreq.organization_id= lv_org_id(k)

Line 12217: FROM msc_department_resources deptres,

12213: Loop
12214: Begin
12215: SELECT 2
12216: Into lv_agg_details(k)
12217: FROM msc_department_resources deptres,
12218: msc_resource_requirements resreq
12219: WHERE resreq.sr_instance_id= lv_instance_id(k)
12220: AND resreq.supply_id = lv_transaction_id(k)
12221: AND resreq.organization_id= lv_org_id(k)