SELECT ORDER_NUMBER
,ORDER_TYPE
,LINE_ID
,CUSTOMER_TRX_ID
,TRX_NUMBER
,INVOICE_AMOUNT
,BATCH_SOURCE
,TRX_DATE
FROM OE_RA_CUSTOMER_TRX_V
WHERE (ORDER_NUMBER = '8002099122')
AND (ORDER_TYPE = 'DROP SHIPMENT200')
AND (LINE_ID = '7384139');
,ORDER_TYPE
,LINE_ID
,CUSTOMER_TRX_ID
,TRX_NUMBER
,INVOICE_AMOUNT
,BATCH_SOURCE
,TRX_DATE
FROM OE_RA_CUSTOMER_TRX_V
WHERE (ORDER_NUMBER = '8002099122')
AND (ORDER_TYPE = 'DROP SHIPMENT200')
AND (LINE_ID = '7384139');