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.

[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_DEPARTMENT_RESOURCES

Line 3935: FROM msc_department_resources deptres,

3931: Loop
3932: Begin
3933: SELECT 2
3934: Into lv_agg_details(k)
3935: FROM msc_department_resources deptres,
3936: msc_resource_requirements resreq
3937: WHERE resreq.sr_instance_id= lv_instance_id(k)
3938: AND resreq.supply_id = lv_transaction_id(k)
3939: AND resreq.organization_id= lv_org_id(k)

Line 4290: msc_department_resources mdr,

4286: From msc_supplies s,
4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,
4291: msc_system_items msi
4292: Where res.plan_id = s.plan_id
4293: AND res.sr_instance_id = s.sr_instance_id
4294: AND s.transaction_id = res.supply_id

Line 4856: FROM msc_department_resources deptres,

4852: Loop
4853: Begin
4854: SELECT 2
4855: Into lv_agg_details(k)
4856: FROM msc_department_resources deptres,
4857: msc_resource_requirements resreq
4858: WHERE resreq.sr_instance_id= lv_instance_id(k)
4859: AND resreq.supply_id = lv_transaction_id(k)
4860: AND resreq.organization_id= lv_org_id(k)

Line 5228: msc_department_resources mdr,

5224: From msc_supplies s,
5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,
5229: msc_system_items msi
5230: Where res.plan_id = s.plan_id
5231: AND res.sr_instance_id = s.sr_instance_id
5232: AND s.transaction_id = res.supply_id

Line 5933: FROM msc_department_resources deptres,

5929: Loop
5930: Begin
5931: SELECT 2
5932: Into lv_agg_details(k)
5933: FROM msc_department_resources deptres,
5934: msc_resource_requirements resreq
5935: WHERE resreq.sr_instance_id= lv_instance_id(k)
5936: AND resreq.supply_id = lv_transaction_id(k)
5937: AND resreq.organization_id= lv_org_id(k)

Line 6379: msc_department_resources mdr

6375: msc_resource_requirements resreq,
6376: msc_parameters param,
6377: msc_system_items msi,
6378: msc_supplies s,
6379: msc_department_resources mdr
6380: WHERE tp.sr_tp_id= msi.organization_id
6381: AND tp.sr_instance_id= msi.sr_instance_id
6382: AND tp.partner_type=3
6383: AND resreq.sr_instance_id= s.sr_instance_id

Line 6870: msc_department_resources mdr

6866: msc_resource_requirements resreq,
6867: msc_parameters param,
6868: msc_system_items msi,
6869: msc_supplies s,
6870: msc_department_resources mdr
6871: WHERE tp.sr_tp_id= msi.organization_id
6872: AND tp.sr_instance_id= msi.sr_instance_id
6873: AND tp.partner_type=3
6874: AND resreq.sr_instance_id= s.sr_instance_id

Line 7376: FROM msc_department_resources deptres,

7372: Loop
7373: Begin
7374: SELECT 2
7375: Into lv_agg_details(k)
7376: FROM msc_department_resources deptres,
7377: msc_resource_requirements resreq
7378: WHERE resreq.sr_instance_id= lv_instance_id(k)
7379: AND resreq.supply_id = lv_transaction_id(k)
7380: AND resreq.organization_id= lv_org_id(k)