eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PA_PROJECTS_ALL

Line 3241: FROM pa_projects_all

3237: --updated to fix project_id related issue start
3238: --updated to fix project_number related issue start
3239: --,prj.segment1 project_number
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

Line 3242: WHERE pa_projects_all.project_id(+) = sub.project_id),

3238: --updated to fix project_number related issue start
3239: --,prj.segment1 project_number
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

Line 3292: ,pa_projects_all prj

3288: ,po_headers_all ph
3289: ,po_vendor_contacts pvc
3290: ,mtl_system_items_vl item_v
3291: ,po_lines_all pl
3292: ,pa_projects_all prj
3293: ,pa_tasks task
3294: ,po_releases_all pra
3295: ,jmf_shikyu_replenishments jsr
3296: ,oe_order_lines_all oola

Line 3719: FROM pa_projects_all

3715: ,cfr_mid_item_group.uom --should jmf_shikyu_components.uom,need rcv.unit_of_measure to conversion?
3716: ,jso.project_id project_id
3717: --Added to fix project_number related issue start
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

Line 3720: WHERE pa_projects_all.project_id(+) = jso.project_id),

3716: ,jso.project_id project_id
3717: --Added to fix project_number related issue start
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