APPS.POS_ASN_XML dependencies on PO_INTERFACE_ERRORS

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

238: p_line_num,
239: p_po_shipment_line_num,
240: p_error_message
241: from
242: rcv_transactions_interface rti, po_interface_errors pie, po_headers_all poh, po_lines_all pol,
243: po_line_locations_all poll
244: where
245: pie.interface_header_id = rti.header_interface_id and
246: pie.interface_type in ('RECEIVING','RCV-856') and

Line 256: rcv_transactions_interface rti, po_interface_errors pie

252:
253: select count(*)
254: into l_count
255: from
256: rcv_transactions_interface rti, po_interface_errors pie
257: where
258: pie.interface_header_id = rti.header_interface_id and
259: -- pie.interface_type in ('RECEIVING','RCV-856') and
260: rti.group_id = p_group_id;

Line 272: rcv_transactions_interface rti, po_interface_errors pie

268: min(pie.error_message)
269: into
270: p_error_message
271: from
272: rcv_transactions_interface rti, po_interface_errors pie
273: where
274: pie.interface_header_id = rti.header_interface_id and
275: -- pie.interface_type in ('RECEIVING','RCV-856') and
276: rti.group_id = p_group_id;