DBA Data[Home] [Help]

APPS.GML_RCV_TXN_INTERFACE dependencies on PO_LINE_LOCATIONS_ALL

Line 296: from po_line_locations_all pll,

292: , pll.ship_to_location_id
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

Line 346: from po_line_locations_all pll,

342: , v_task_id NUMBER)
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)