APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on STANDARD

Line 303: WHERE --h.type_lookup_code IN ('STANDARD')

299: union
300: select distinct project_id, project_number
301: from pjm_seiban_numbers) proj,
302: pa_tasks pt
303: WHERE --h.type_lookup_code IN ('STANDARD')
304: h.po_header_id = sub.subcontract_po_header_id
305: AND l.po_line_id = sub.subcontract_po_line_id
306: AND loc.line_location_id = sub.subcontract_po_shipment_id
307: AND pvsa.vendor_site_id(+) = h.vendor_site_id