APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 1576: msc_resource_instance_reqs res_instreq,

1572: , 1
1573: FROM
1574: msc_trading_partners tp,
1575: msc_resource_requirements resreq,
1576: msc_resource_instance_reqs res_instreq,
1577: msc_supplies s,
1578: msc_apps_instances ins,
1579: msc_parameters param
1580: WHERE

Line 1683: msc_resource_instance_reqs res_instreq,

1679: , 1
1680: FROM
1681: msc_trading_partners tp,
1682: msc_resource_requirements resreq,
1683: msc_resource_instance_reqs res_instreq,
1684: msc_supplies s,
1685: msc_apps_instances ins,
1686: msc_parameters param
1687: WHERE

Line 2460: msc_resource_instance_reqs res_instreq,

2456: resreq.resource_id,
2457: 1
2458: FROM msc_trading_partners tp,
2459: msc_resource_requirements resreq,
2460: msc_resource_instance_reqs res_instreq,
2461: msc_supplies s,
2462: msc_apps_instances ins,
2463: msc_parameters param
2464: WHERE

Line 2567: msc_resource_instance_reqs res_instreq,

2563: , 1
2564: FROM
2565: msc_trading_partners tp,
2566: msc_resource_requirements resreq,
2567: msc_resource_instance_reqs res_instreq,
2568: msc_supplies s,
2569: msc_apps_instances ins,
2570: msc_parameters param
2571: WHERE

Line 3595: msc_resource_instance_reqs res_instreq,

3591: resreq.parent_seq_num
3592: FROM
3593: msc_trading_partners tp,
3594: msc_resource_requirements resreq,
3595: msc_resource_instance_reqs res_instreq,
3596: msc_dept_res_instances dep_res_inst,
3597: msc_supplies s
3598: WHERE
3599: tp.sr_tp_id=s.organization_id

Line 3700: msc_resource_instance_reqs res_instreq,

3696: resreq.parent_seq_num
3697: FROM
3698: msc_trading_partners tp,
3699: msc_resource_requirements resreq,
3700: msc_resource_instance_reqs res_instreq,
3701: msc_supplies s
3702: WHERE
3703: tp.sr_tp_id=s.organization_id
3704: AND tp.sr_instance_id= s.sr_instance_id

Line 4688: msc_resource_instance_reqs res_instreq,

4684: , resreq.parent_seq_num
4685: FROM
4686: msc_trading_partners tp,
4687: msc_resource_requirements resreq,
4688: msc_resource_instance_reqs res_instreq,
4689: msc_supplies s
4690: WHERE
4691: tp.sr_tp_id=s.organization_id
4692: AND tp.sr_instance_id= s.sr_instance_id

Line 4787: msc_resource_instance_reqs res_instreq,

4783: ,resreq.parent_seq_num
4784: FROM
4785: msc_trading_partners tp,
4786: msc_resource_requirements resreq,
4787: msc_resource_instance_reqs res_instreq,
4788: msc_supplies s
4789: WHERE
4790: tp.sr_tp_id=s.organization_id
4791: AND tp.sr_instance_id= s.sr_instance_id