DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on PJM_PROJECTS_MTLL_V

Line 399: from pjm_projects_mtll_v ppov

395:
396: Begin
397:
398: select distinct ppov.project_name into l_project_name
399: from pjm_projects_mtll_v ppov
400: where ppov.project_id = p_project_id;
401:
402: Return l_project_name;
403: Exception

Line 422: FROM pjm_tasks_mtll_v ptev, pjm_projects_mtll_v p

418: Begin
419:
420: -------------------
421: SELECT nvl(p.project_number, '') || ' / ' || nvl(ptev.TASK_NUMBER, '') into l_task_name
422: FROM pjm_tasks_mtll_v ptev, pjm_projects_mtll_v p
423: where p.project_id = ptev.project_id
424: and ptev.project_id = p_project_id
425: and ptev.task_id = p_task_id;
426: -------------