APPS.POS_ASN dependencies on PO_INTERFACE_ERRORS

Line 38: from po_interface_errors err,

34: '', '-' ||
35: TO_CHAR(ASND.ASN_LINE_SPLIT_ID)) error_seq,
36: replace(replace(err.error_message, '
37: ', null), '''', '\''') error_message
38: from po_interface_errors err,
39: pos_asn_shop_cart_details asnd
40: where err.INTERFACE_HEADER_ID = l_header_id and
41: asnd.HEADER_INTERFACE_ID = err.INTERFACE_HEADER_ID and
42: asnd.INTERFACE_TRANSACTION_ID = err.INTERFACE_LINE_ID;

Line 47: from po_interface_errors err

43:
44: cursor c_header_err is
45: select replace(replace(err.error_message,'
46: ', null),'''', '\''') error_message
47: from po_interface_errors err
48: where INTERFACE_HEADER_ID = l_header_id and
49: INTERFACE_LINE_ID is null;
50:
51: