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 966: FROM msc_department_resources deptres,

962: Loop
963: Begin
964: SELECT 2
965: Into lv_agg_details(k)
966: FROM msc_department_resources deptres,
967: msc_resource_requirements resreq
968: WHERE resreq.sr_instance_id= lv_instance_id(k)
969: AND resreq.supply_id = lv_transaction_id(k)
970: AND resreq.organization_id= lv_org_id(k)

Line 1334: msc_department_resources mdr,

1330: From msc_supplies s,
1331: msc_resource_requirements res,
1332: msc_apps_instances ins,
1333: msc_parameters param,
1334: msc_department_resources mdr,
1335: msc_system_items msi
1336: Where res.plan_id = s.plan_id
1337: AND res.sr_instance_id = s.sr_instance_id
1338: AND s.transaction_id = res.supply_id

Line 1822: FROM msc_department_resources deptres,

1818: Loop
1819: Begin
1820: SELECT 2
1821: Into lv_agg_details(k)
1822: FROM msc_department_resources deptres,
1823: msc_resource_requirements resreq
1824: WHERE resreq.sr_instance_id= lv_instance_id(k)
1825: AND resreq.supply_id = lv_transaction_id(k)
1826: AND resreq.organization_id= lv_org_id(k)

Line 2211: msc_department_resources mdr,

2207: From msc_supplies s,
2208: msc_resource_requirements res,
2209: msc_apps_instances ins,
2210: msc_parameters param,
2211: msc_department_resources mdr,
2212: msc_system_items msi
2213: Where res.plan_id = s.plan_id
2214: AND res.sr_instance_id = s.sr_instance_id
2215: AND s.transaction_id = res.supply_id

Line 2762: FROM msc_department_resources deptres,

2758: Loop
2759: Begin
2760: SELECT 2
2761: Into lv_agg_details(k)
2762: FROM msc_department_resources deptres,
2763: msc_resource_requirements resreq
2764: WHERE resreq.sr_instance_id= lv_instance_id(k)
2765: AND resreq.supply_id = lv_transaction_id(k)
2766: AND resreq.organization_id= lv_org_id(k)

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

3117: FROM msc_trading_partners tp,
3118: msc_resource_requirements resreq,
3119: msc_parameters param,
3120: msc_supplies s,
3121: msc_department_resources mdr --MN: "C" type , can we just say mdr.plan_id = -1 ??
3122: WHERE tp.sr_tp_id= s.organization_id
3123: AND tp.sr_instance_id= s.sr_instance_id
3124: AND tp.partner_type=3
3125: AND resreq.sr_instance_id= s.sr_instance_id

Line 3524: msc_department_resources mdr

3520: FROM msc_trading_partners tp,
3521: msc_resource_requirements resreq,
3522: msc_parameters param,
3523: msc_supplies s,
3524: msc_department_resources mdr
3525: WHERE tp.sr_tp_id= s.organization_id
3526: AND tp.sr_instance_id= s.sr_instance_id
3527: AND tp.partner_type=3
3528: AND resreq.sr_instance_id= s.sr_instance_id

Line 3852: FROM msc_department_resources deptres,

3848: Loop
3849: Begin
3850: SELECT 2
3851: Into lv_agg_details(k)
3852: FROM msc_department_resources deptres,
3853: msc_resource_requirements resreq
3854: WHERE resreq.sr_instance_id= lv_instance_id(k)
3855: AND resreq.supply_id = lv_transaction_id(k)
3856: AND resreq.organization_id= lv_org_id(k)