DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_DEPT_RES_INSTANCES

Line 5114: msc_dept_res_instances dep_res_inst,

5110: FROM
5111: msc_trading_partners tp,
5112: msc_resource_requirements resreq,
5113: msc_resource_instance_reqs res_instreq, -- changed from design doc
5114: msc_dept_res_instances dep_res_inst,
5115: msc_supplies s,
5116: msc_apps_instances ins,
5117: msc_parameters param
5118: WHERE

Line 5233: msc_dept_res_instances dep_res_inst,

5229: FROM
5230: msc_trading_partners tp,
5231: msc_resource_requirements resreq,
5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,
5235: msc_apps_instances ins,
5236: msc_parameters param
5237: WHERE

Line 6066: msc_dept_res_instances dep_res_inst,

6062: 1
6063: FROM msc_trading_partners tp,
6064: msc_resource_requirements resreq,
6065: msc_resource_instance_reqs res_instreq, -- changed from design doc
6066: msc_dept_res_instances dep_res_inst,
6067: msc_supplies s,
6068: msc_apps_instances ins,
6069: msc_parameters param
6070: WHERE

Line 6184: msc_dept_res_instances dep_res_inst,

6180: FROM
6181: msc_trading_partners tp,
6182: msc_resource_requirements resreq,
6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,
6186: msc_apps_instances ins,
6187: msc_parameters param
6188: WHERE

Line 7661: msc_dept_res_instances dep_res_inst,

7657: FROM
7658: msc_trading_partners tp,
7659: msc_resource_requirements resreq,
7660: msc_resource_instance_reqs res_instreq,
7661: msc_dept_res_instances dep_res_inst,
7662: msc_supplies s
7663: WHERE
7664: tp.sr_tp_id=s.organization_id
7665: AND tp.sr_instance_id= s.sr_instance_id

Line 7773: msc_dept_res_instances dep_res_inst,

7769: FROM
7770: msc_trading_partners tp,
7771: msc_resource_requirements resreq,
7772: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7773: msc_dept_res_instances dep_res_inst,
7774: msc_supplies s
7775: WHERE
7776: tp.sr_tp_id=s.organization_id
7777: AND tp.sr_instance_id= s.sr_instance_id

Line 9068: msc_dept_res_instances dep_res_inst,

9064: FROM
9065: msc_trading_partners tp,
9066: msc_resource_requirements resreq,
9067: msc_resource_instance_reqs res_instreq,
9068: msc_dept_res_instances dep_res_inst,
9069: msc_supplies s
9070: WHERE
9071: tp.sr_tp_id=s.organization_id
9072: AND tp.sr_instance_id= s.sr_instance_id

Line 9186: msc_dept_res_instances dep_res_inst,

9182: FROM
9183: msc_trading_partners tp,
9184: msc_resource_requirements resreq,
9185: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
9186: msc_dept_res_instances dep_res_inst,
9187: msc_supplies s
9188: WHERE
9189: tp.sr_tp_id=s.organization_id
9190: AND tp.sr_instance_id= s.sr_instance_id

Line 11772: msc_dept_res_instances dep_res_inst,

11768: FROM
11769: msc_trading_partners tp,
11770: msc_resource_requirements resreq,
11771: msc_resource_instance_reqs res_instreq,
11772: msc_dept_res_instances dep_res_inst,
11773: msc_supplies s
11774: WHERE
11775: tp.sr_tp_id=s.organization_id
11776: AND tp.sr_instance_id= s.sr_instance_id

Line 11892: msc_dept_res_instances dep_res_inst,

11888: FROM
11889: msc_trading_partners tp,
11890: msc_resource_requirements resreq,
11891: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
11892: msc_dept_res_instances dep_res_inst,
11893: msc_supplies s
11894: WHERE
11895: tp.sr_tp_id=s.organization_id
11896: AND tp.sr_instance_id= s.sr_instance_id

Line 13103: msc_dept_res_instances dep_res_inst,

13099: FROM
13100: msc_trading_partners tp,
13101: msc_resource_requirements resreq,
13102: msc_resource_instance_reqs res_instreq,
13103: msc_dept_res_instances dep_res_inst,
13104: msc_supplies s
13105: WHERE
13106: tp.sr_tp_id=s.organization_id
13107: AND tp.sr_instance_id= s.sr_instance_id

Line 13223: msc_dept_res_instances dep_res_inst,

13219: FROM
13220: msc_trading_partners tp,
13221: msc_resource_requirements resreq,
13222: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
13223: msc_dept_res_instances dep_res_inst,
13224: msc_supplies s
13225: WHERE
13226: tp.sr_tp_id=s.organization_id
13227: AND tp.sr_instance_id= s.sr_instance_id