APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 1602: msc_resource_instance_reqs res_instreq,

1598: , 1
1599: FROM
1600: msc_trading_partners tp,
1601: msc_resource_requirements resreq,
1602: msc_resource_instance_reqs res_instreq,
1603: msc_supplies s,
1604: msc_apps_instances ins,
1605: msc_parameters param
1606: WHERE

Line 1709: msc_resource_instance_reqs res_instreq,

1705: , 1
1706: FROM
1707: msc_trading_partners tp,
1708: msc_resource_requirements resreq,
1709: msc_resource_instance_reqs res_instreq,
1710: msc_supplies s,
1711: msc_apps_instances ins,
1712: msc_parameters param
1713: WHERE

Line 2487: msc_resource_instance_reqs res_instreq,

2483: resreq.resource_id,
2484: 1
2485: FROM msc_trading_partners tp,
2486: msc_resource_requirements resreq,
2487: msc_resource_instance_reqs res_instreq,
2488: msc_supplies s,
2489: msc_apps_instances ins,
2490: msc_parameters param
2491: WHERE

Line 2594: msc_resource_instance_reqs res_instreq,

2590: , 1
2591: FROM
2592: msc_trading_partners tp,
2593: msc_resource_requirements resreq,
2594: msc_resource_instance_reqs res_instreq,
2595: msc_supplies s,
2596: msc_apps_instances ins,
2597: msc_parameters param
2598: WHERE

Line 3622: msc_resource_instance_reqs res_instreq,

3618: resreq.parent_seq_num
3619: FROM
3620: msc_trading_partners tp,
3621: msc_resource_requirements resreq,
3622: msc_resource_instance_reqs res_instreq,
3623: msc_dept_res_instances dep_res_inst,
3624: msc_supplies s
3625: WHERE
3626: tp.sr_tp_id=s.organization_id

Line 3727: msc_resource_instance_reqs res_instreq,

3723: resreq.parent_seq_num
3724: FROM
3725: msc_trading_partners tp,
3726: msc_resource_requirements resreq,
3727: msc_resource_instance_reqs res_instreq,
3728: msc_supplies s
3729: WHERE
3730: tp.sr_tp_id=s.organization_id
3731: AND tp.sr_instance_id= s.sr_instance_id

Line 5072: msc_resource_instance_reqs res_instreq,

5068: , resreq.parent_seq_num
5069: FROM
5070: msc_trading_partners tp,
5071: msc_resource_requirements resreq,
5072: msc_resource_instance_reqs res_instreq,
5073: msc_supplies s
5074: WHERE
5075: tp.sr_tp_id=s.organization_id
5076: AND tp.sr_instance_id= s.sr_instance_id

Line 5171: msc_resource_instance_reqs res_instreq,

5167: ,resreq.parent_seq_num
5168: FROM
5169: msc_trading_partners tp,
5170: msc_resource_requirements resreq,
5171: msc_resource_instance_reqs res_instreq,
5172: msc_supplies s
5173: WHERE
5174: tp.sr_tp_id=s.organization_id
5175: AND tp.sr_instance_id= s.sr_instance_id