APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on STANDARD

Line 280: WHERE \*h.type_lookup_code IN ('STANDARD') AND *\

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
283: AND sub.project_id = pa.project_id(+)
284: AND sub.task_id = tasks.task_id(+)

Line 316: --WHERE /*h.type_lookup_code IN ('standard') AND */

312: ,hr_all_organization_units_tl haotl
313: --Added to display release_number
314: ,po_releases_all pra
315: --updated to fix project_number related issue start
316: --WHERE /*h.type_lookup_code IN ('standard') AND */
317: --pa.project_id(+) = sub.project_id
318: --AND tasks.task_id(+) = sub.task_id
319: WHERE tasks.task_id(+) = sub.task_id
320: --updated to fix project_number related issue end