APPS.POS_ASN_XML dependencies on PO_INTERFACE_ERRORS

Line 252: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,

248: p_line_num,
249: p_po_shipment_line_num,
250: p_error_message
251: from
252: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
253: po_line_locations_all poll
254: where
255: pie.interface_header_id = rti.header_interface_id and
256: pie.interface_type in ('RECEIVING','RCV-856') and

Line 266: rcv_transactions_interface rti, po_interface_errors pie

262:
263: select count(*)
264: into l_count
265: from
266: rcv_transactions_interface rti, po_interface_errors pie
267: where
268: pie.interface_header_id = rti.header_interface_id and
269: -- pie.interface_type in ('RECEIVING','RCV-856') and
270: rti.group_id = p_group_id;

Line 282: rcv_transactions_interface rti, po_interface_errors pie

278: min(pie.error_message)
279: into
280: p_error_message
281: from
282: rcv_transactions_interface rti, po_interface_errors pie
283: where
284: pie.interface_header_id = rti.header_interface_id and
285: -- pie.interface_type in ('RECEIVING','RCV-856') and
286: rti.group_id = p_group_id;