116: decode(l.default_ussgl_transaction_code, null,
117: h.default_ussgl_transaction_code,
118: l.default_ussgl_transaction_code )
119: )
120: FROM ar_trx_dist_gt d,
121: ar_trx_header_gt h,
122: ar_trx_lines_gt l
123: WHERE d.trx_line_id = l.trx_line_id(+)
124: and d.trx_header_id = h.trx_header_id
126: ar_trx_errors_gt )
127: AND d.trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
128: AND d.process_flag = 'N';
129:
130: UPDATE ar_trx_dist_gt
131: SET process_flag = 'Y'
132: WHERE trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
133: AND process_flag = 'N'
134: AND trx_header_ID NOT IN