APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on PA_TASKS

Line 278: ,pa_tasks tasks

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
282: AND l.po_line_id = sub.subcontract_po_line_id

Line 300: -- ,pa_tasks tasks

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
304: ,po_vendors ven

Line 301: FROM pa_tasks tasks

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
304: ,po_vendors ven
305: ,mtl_system_items_vl mtl

Line 631: ,pa_tasks tasks

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
634: --updated to fix project_number related issue start
635: --WHERE pa.project_id(+) = sol.project_id

Line 1070: ,pa_tasks tasks

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
1074: AND tasks.task_id(+) = sol.task_id