APPS.MSC_REL_PLAN_PUB dependencies on MSC_DEPT_RES_INSTANCES

Line 4565: msc_dept_res_instances dep_res_inst,

4561: FROM
4562: msc_trading_partners tp,
4563: msc_resource_requirements resreq,
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,
4567: msc_apps_instances ins,
4568: msc_parameters param
4569: WHERE

Line 4684: msc_dept_res_instances dep_res_inst,

4680: FROM
4681: msc_trading_partners tp,
4682: msc_resource_requirements resreq,
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,
4686: msc_apps_instances ins,
4687: msc_parameters param
4688: WHERE

Line 5510: msc_dept_res_instances dep_res_inst,

5506: 1
5507: FROM msc_trading_partners tp,
5508: msc_resource_requirements resreq,
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,
5512: msc_apps_instances ins,
5513: msc_parameters param
5514: WHERE

Line 5628: msc_dept_res_instances dep_res_inst,

5624: FROM
5625: msc_trading_partners tp,
5626: msc_resource_requirements resreq,
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,
5630: msc_apps_instances ins,
5631: msc_parameters param
5632: WHERE

Line 6982: msc_dept_res_instances dep_res_inst,

6978: FROM
6979: msc_trading_partners tp,
6980: msc_resource_requirements resreq,
6981: msc_resource_instance_reqs res_instreq,
6982: msc_dept_res_instances dep_res_inst,
6983: msc_supplies s
6984: WHERE
6985: tp.sr_tp_id=s.organization_id
6986: AND tp.sr_instance_id= s.sr_instance_id

Line 7094: msc_dept_res_instances dep_res_inst,

7090: FROM
7091: msc_trading_partners tp,
7092: msc_resource_requirements resreq,
7093: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7094: msc_dept_res_instances dep_res_inst,
7095: msc_supplies s
7096: WHERE
7097: tp.sr_tp_id=s.organization_id
7098: AND tp.sr_instance_id= s.sr_instance_id

Line 8225: msc_dept_res_instances dep_res_inst,

8221: FROM
8222: msc_trading_partners tp,
8223: msc_resource_requirements resreq,
8224: msc_resource_instance_reqs res_instreq,
8225: msc_dept_res_instances dep_res_inst,
8226: msc_supplies s
8227: WHERE
8228: tp.sr_tp_id=s.organization_id
8229: AND tp.sr_instance_id= s.sr_instance_id

Line 8343: msc_dept_res_instances dep_res_inst,

8339: FROM
8340: msc_trading_partners tp,
8341: msc_resource_requirements resreq,
8342: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
8343: msc_dept_res_instances dep_res_inst,
8344: msc_supplies s
8345: WHERE
8346: tp.sr_tp_id=s.organization_id
8347: AND tp.sr_instance_id= s.sr_instance_id