APPS.GML_RCV_TXN_INTERFACE dependencies on PO_LINES_ALL

Line 297: po_lines_all pl,

293: , nvl(pll.enforce_ship_to_location_code,'NONE') enforce_ship_to_location_code
294: , 0 rcv_transaction_id -- only need it for std_deliver
295: , pl.item_revision --only needed for std_deliver
296: from po_line_locations_all pll,
297: po_lines_all pl,
298: po_headers_all ph
299: where ph.po_header_id = header_id
300: and pll.po_header_id = header_id
301: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)

Line 347: po_lines_all pl

343:
344: IS
345: SELECT COUNT(*)
346: from po_line_locations_all pll,
347: po_lines_all pl
348: WHERE pll.po_header_id = header_id
349: AND pll.po_line_id = Nvl(v_po_line_id, pll.po_line_id)
350: AND pll.line_location_id = Nvl(v_po_line_location_id, pll.line_location_id)
351: and nvl(pll.po_release_id,0) = nvl(v_po_release_id,nvl(pll.po_release_id,0))