DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 661: msc_resource_instance_reqs mrir,

657: FROM
658: msc_resource_requirements crp,
659: msc_department_resources cpr,
660: msc_dept_res_instances mdri,
661: msc_resource_instance_reqs mrir,
662: msc_form_query list
663: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
664: AND cpr.resource_id = list.number3
665: AND cpr.plan_id = g_designator

Line 743: msc_resource_instance_reqs mrir,

739: FROM
740: msc_resource_requirements crp,
741: msc_department_resources cpr,
742: msc_dept_res_instances mdri,
743: msc_resource_instance_reqs mrir,
744: msc_form_query list
745: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
746: AND cpr.resource_id = list.number3
747: AND cpr.plan_id = g_designator