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 3722: FROM pjm_seiban_numbers

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

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

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