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_CUR_PVT dependencies on PA_PROJECTS_ALL

Line 231: FROM pa_projects_all

227: ,haotl.NAME
228: --updated to fix project_number related issue start
229: --,pa.segment1
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

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

228: --updated to fix project_number related issue start
229: --,pa.segment1
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

Line 277: ,pa_projects_all pa

273: ,jmf_subcontract_orders sub
274: ,mtl_system_items_vl mtl
275: ,po_vendor_sites_all pv
276: ,hr_all_organization_units_tl haotl
277: ,pa_projects_all pa
278: ,pa_tasks tasks
279: ,po_vendors ven
280: WHERE \*h.type_lookup_code IN ('STANDARD') AND *\
281: h.po_header_id = sub.subcontract_po_header_id

Line 299: --FROM pa_projects_all pa

295: ,haotl.NAME)
296: AND haotl.NAME <= nvl(lp_inv_org_name_to
297: ,haotl.NAME);*/
298: --updated to fix project_number related issue start
299: --FROM pa_projects_all pa
300: -- ,pa_tasks tasks
301: FROM pa_tasks tasks
302: --updated to fix project_number related issue end
303: ,po_vendor_sites_all pv

Line 584: FROM pa_projects_all

580: ,haotl.NAME
581: --updated to fix project_number related issue start
582: --,pa.segment1
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

Line 585: WHERE pa_projects_all.project_id(+) = sol.project_id),

581: --updated to fix project_number related issue start
582: --,pa.segment1
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

Line 629: --,pa_projects_all pa

625: FROM oe_order_headers_all soh
626: ,oe_order_lines_all sol
627: ,hr_all_organization_units_tl haotl
628: --updated to fix project_number related issue start
629: --,pa_projects_all pa
630: --updated to fix project_number related issue end
631: ,pa_tasks tasks
632: ,jmf_shikyu_replenishments repo
633: ,mtl_system_items_vl mtl

Line 1069: ,pa_projects_all pa

1065: ,l_om_ship_from_org_id
1066: ,l_actual_shipment_date
1067: FROM oe_order_headers_all soh
1068: ,oe_order_lines_all sol
1069: ,pa_projects_all pa
1070: ,pa_tasks tasks
1071: ,jmf_shikyu_replenishments repo
1072: ,mtl_system_items_vl mtl
1073: WHERE pa.project_id(+) = sol.project_id