DBA Data[Home] [Help]

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINE_LOCATIONS_INTERFACE

Line 247: po_line_locations_interface pll,

243: UNION
244: SELECT pui.interface_line_id
245: FROM po_headers_interface phi,
246: po_lines_interface pli,
247: po_line_locations_interface pll,
248: po_uda_interface pui
249: WHERE phi.interface_header_id = p_interface_header_id
250: AND pli.interface_header_id = phi.interface_header_id
251: AND pli.interface_line_id = pll.interface_line_id

Line 345: FROM PO_LINE_LOCATIONS_INTERFACE

341: 'PO_LINE_EXT_ATTRS' , (SELECT PO_LINE_ID
342: FROM po_lines_interface
343: WHERE interface_line_id = interface_reference_id),
344: 'PO_SHIPMENTS_EXT_ATTRS' , (SELECT LINE_LOCATION_ID
345: FROM PO_LINE_LOCATIONS_INTERFACE
346: WHERE interface_line_location_id = interface_reference_id)
347: ),
348: pk2_value = -1
349: WHERE interface_line_id = l_uda_lines_tbl(i);