DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 812: msc_resource_instance_reqs mrir,

808: FROM
809: msc_resource_requirements crp,
810: msc_department_resources cpr,
811: msc_dept_res_instances mdri,
812: msc_resource_instance_reqs mrir,
813: msc_form_query list
814: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
815: AND cpr.resource_id = list.number3
816: AND cpr.plan_id = g_designator

Line 903: msc_resource_instance_reqs mrir,

899: FROM
900: msc_resource_requirements crp,
901: msc_department_resources cpr,
902: msc_dept_res_instances mdri,
903: msc_resource_instance_reqs mrir,
904: msc_form_query list
905: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
906: AND cpr.resource_id = list.number3
907: AND cpr.plan_id = g_designator