APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on PJM_SEIBAN_NUMBERS

Line 234: FROM pjm_seiban_numbers

230: ,NVL((SELECT DISTINCT segment1 AS project_number
231: FROM pa_projects_all
232: WHERE pa_projects_all.project_id(+) = sub.project_id),
233: (SELECT DISTINCT project_number
234: FROM pjm_seiban_numbers
235: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) segment1
236: --updated to fix project_number related issue end
237: ,tasks.task_number
238: ,ven.vendor_name

Line 235: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) segment1

231: FROM pa_projects_all
232: WHERE pa_projects_all.project_id(+) = sub.project_id),
233: (SELECT DISTINCT project_number
234: FROM pjm_seiban_numbers
235: WHERE pjm_seiban_numbers.project_id(+) = sub.project_id)) segment1
236: --updated to fix project_number related issue end
237: ,tasks.task_number
238: ,ven.vendor_name
239: ,pv.vendor_site_code

Line 587: FROM pjm_seiban_numbers

583: ,NVL((SELECT DISTINCT segment1 AS project_number
584: FROM pa_projects_all
585: WHERE pa_projects_all.project_id(+) = sol.project_id),
586: (SELECT DISTINCT project_number
587: FROM pjm_seiban_numbers
588: WHERE pjm_seiban_numbers.project_id(+) = sol.project_id)) segment1
589: --updated to fix project_number related issue end
590: ,tasks.task_number
591: ,soh.order_number

Line 588: WHERE pjm_seiban_numbers.project_id(+) = sol.project_id)) segment1

584: FROM pa_projects_all
585: WHERE pa_projects_all.project_id(+) = sol.project_id),
586: (SELECT DISTINCT project_number
587: FROM pjm_seiban_numbers
588: WHERE pjm_seiban_numbers.project_id(+) = sol.project_id)) segment1
589: --updated to fix project_number related issue end
590: ,tasks.task_number
591: ,soh.order_number
592: ,sol.line_number