DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on STANDARD

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

312: union
313: select distinct project_id, project_number
314: from pjm_seiban_numbers) proj,
315: pa_tasks pt
316: WHERE --h.type_lookup_code IN ('STANDARD')
317: h.po_header_id = sub.subcontract_po_header_id
318: AND l.po_line_id = sub.subcontract_po_line_id
319: AND loc.line_location_id = sub.subcontract_po_shipment_id
320: AND pvsa.vendor_site_id(+) = h.vendor_site_id