DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on PJM_PROJECTS_ALL_OU_V

Line 1730: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project

1726: IF inv_mwb_globals.g_project_number IS NOT NULL THEN
1727: UPDATE MTL_MWB_GTMP
1728: SET project_number = inv_mwb_globals.g_project_number
1729: , (project_id, project_name)= (SELECT project_id, project_name
1730: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project
1731: WHERE project_number = inv_mwb_globals.g_project_number);
1732:
1733: ELSE
1734: IF l_project_id IS NOT NULL THEN

Line 1737: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project

1733: ELSE
1734: IF l_project_id IS NOT NULL THEN
1735: UPDATE MTL_MWB_GTMP
1736: SET (project_number, project_name) = (SELECT project_number, project_name
1737: FROM pjm_projects_all_ou_v --Bug 14751814,also display closed project
1738: WHERE project_id = l_project_id) ,
1739: project_id = l_project_id
1740: WHERE locator_id = rec.locator_id;
1741: END IF;