APPS.INV_UI_PROJECT_LOVS dependencies on RCV_SHIPMENT_LINES

Line 247: rcv_shipment_lines rsl

243: p.project_number,
244: p.project_name
245: FROM po_distributions_all pod,
246: pjm_projects_mtll_v p,
247: rcv_shipment_lines rsl
248: WHERE pod.project_id IS NOT NULL
249: AND pod.po_header_id = rsl.po_header_id
250: AND pod.project_id = p.project_id
251: AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )

Line 275: rcv_shipment_lines rsl

271: p.project_number,
272: p.project_name
273: FROM po_distributions_all pod,
274: pjm_projects_mtll_v p,
275: rcv_shipment_lines rsl
276: WHERE pod.project_id IS NOT NULL
277: AND pod.po_header_id = rsl.po_header_id
278: AND pod.project_id = p.project_id
279: AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )

Line 301: rcv_shipment_lines rsl

297: SELECT DISTINCT -9999 project_id,
298: l_no_proj_str project_number,
299: l_no_proj_str project_name
300: FROM po_distributions_all pod,
301: rcv_shipment_lines rsl
302: WHERE pod.project_id IS NULL
303: AND pod.po_header_id = rsl.po_header_id
304: AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )
305: AND l_no_proj_str LIKE ( p_project_number )