[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ar_trx_lines_gt.trx_line_id
, ar_trx_header_gt.cust_trx_type_id trx_type
, ar_trx_header_gt.trx_date
, nvl(ship_to_address_id , bill_to_address_id)
ship_to_address_id
, ar_trx_lines_gt.line_type
, ar_trx_lines_gt.memo_line_id
, ar_trx_lines_gt.inventory_item_id
, ar_trx_header_gt.global_attribute1
, ar_trx_header_gt.global_attribute2
, ar_trx_header_gt.global_attribute3
, ar_trx_header_gt.global_attribute4
, ar_trx_header_gt.global_attribute5
, ar_trx_header_gt.global_attribute6
, ar_trx_header_gt.global_attribute7
, ar_trx_header_gt.global_attribute8
, ar_trx_header_gt.global_attribute9
, ar_trx_header_gt.global_attribute10
, ar_trx_header_gt.global_attribute11
, ar_trx_header_gt.global_attribute12
, ar_trx_header_gt.global_attribute13
, ar_trx_header_gt.global_attribute14
, ar_trx_header_gt.global_attribute15
, ar_trx_header_gt.global_attribute16
, ar_trx_header_gt.global_attribute17
, ar_trx_lines_gt.global_attribute1
, ar_trx_lines_gt.global_attribute4
, ar_trx_lines_gt.global_attribute5
, ar_trx_lines_gt.global_attribute6
, ar_trx_lines_gt.global_attribute7
, ar_trx_lines_gt.global_attribute8
, ar_trx_lines_gt.global_attribute9
, ar_trx_lines_gt.global_attribute10
, ar_trx_lines_gt.global_attribute11
, ar_trx_lines_gt.global_attribute12
, warehouse_id
, rbs.name
, ar_trx_header_gt.trx_number
FROM ar_trx_lines_gt,ar_trx_header_gt,ra_batch_sources_all rbs
WHERE ar_trx_lines_gt.request_id = c_request_id
AND ar_trx_header_gt.trx_header_id = ar_trx_lines_gt.trx_header_id
AND ar_trx_header_gt.batch_source_id = rbs.batch_source_id
ORDER BY ar_trx_header_gt.trx_date;