APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PJM_SEIBAN_NUMBERS

Line 3244: FROM pjm_seiban_numbers

3240: ,NVL((SELECT DISTINCT segment1 AS project_number
3241: FROM pa_projects_all
3242: WHERE pa_projects_all.project_id(+) = sub.project_id),
3243: (SELECT DISTINCT project_number
3244: FROM pjm_seiban_numbers
3245: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) project_number
3246: --updated to fix project_number related issue end
3247: --updated to fix project_id related issue start
3248: --,rcv.task_id task_id

Line 3245: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) project_number

3241: FROM pa_projects_all
3242: WHERE pa_projects_all.project_id(+) = sub.project_id),
3243: (SELECT DISTINCT project_number
3244: FROM pjm_seiban_numbers
3245: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) project_number
3246: --updated to fix project_number related issue end
3247: --updated to fix project_id related issue start
3248: --,rcv.task_id task_id
3249: ,sub.task_id task_id

Line 3725: FROM pjm_seiban_numbers

3721: ,NVL((SELECT DISTINCT segment1 AS project_number
3722: FROM pa_projects_all
3723: WHERE pa_projects_all.project_id(+) = jso.project_id),
3724: (SELECT DISTINCT project_number
3725: FROM pjm_seiban_numbers
3726: WHERE pjm_seiban_numbers.project_id(+) = jso.project_id)) project_number
3727: --Added to fix project_number related issue end
3728: ,jso.task_id task_id
3729: --Added to get task number start

Line 3726: WHERE pjm_seiban_numbers.project_id(+) = jso.project_id)) project_number

3722: FROM pa_projects_all
3723: WHERE pa_projects_all.project_id(+) = jso.project_id),
3724: (SELECT DISTINCT project_number
3725: FROM pjm_seiban_numbers
3726: WHERE pjm_seiban_numbers.project_id(+) = jso.project_id)) project_number
3727: --Added to fix project_number related issue end
3728: ,jso.task_id task_id
3729: --Added to get task number start
3730: ,task.task_number task_number