-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathoutput1.sql
More file actions
34 lines (34 loc) · 21.3 KB
/
output1.sql
File metadata and controls
34 lines (34 loc) · 21.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
SELECT ELSEELSE, b.EXP_ISSUE_DATE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.EXP_ISSUE_TIME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.CERTI_AUTH, b.CERTIFYING_AUTHORITY from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.CERTI_PLACE, b.CERTIFYING_PLACE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.CERTIFYING_DATE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.TRANS_ID, b.TRANSACTION_ID from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.VAN_ID, b.VAN_ID from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.SENDER_ID, b.SENDER_NAME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT , b.SENDER_ID from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.UNB_DATE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.UNB_TIME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.CONTROL_NUMBER, b.CONTROL_NO from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.MSG_FUNC_CD, b.MESSAGE_FUNCTION from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.DECL_NO, b.DECL_NO from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.CUSTOMS_MESSAGE_ID, b.CUSTOMS_MESSAGE_ID from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.PORT_CD, b.SHIPMENT from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.SAL_ENAME, b.SUPPLIER_NAME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.SAL_EADDR, b.SUPPLIER_ADDRESS from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.DUTY_PAYER_ENAME, b.DUTY_PAYER_NAME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.DUTY_PAYER_BAN, b.DUTY_PAYER_BAN from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.DUTY_PAYER_EADDR, b.DUTY_PAYER_ADDRESS from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.UNLOAD_PORT, b.UNLOADING_PORT from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.DEST_CD, b.FINAL_CNTRY_CD from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.VOYAGE_NO, b.VOYAG_NO from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.CERT_NO, b.CERTIFICATE_NO from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.REF_CD, b.REFERENCE_CODE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.ORG_COUNTRY_CD, b.ORIG_CNTRY_CD from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT a.EX_ISSUE_PLACE, b.EXP_ISSUE_PLACE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.CERTIFYING_TIME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.DEAL_DATE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.XML_EDI_FLAG from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.RECEIVER_NAME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.APFI_DATE from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%' SQL_LOG
SELECT ELSEELSE, b.APFI_TIME from dsw_eco01_s1 a, dgoc_ap_eco01a0 b where a.customs_message_id = b.customs_message_id and a.trans_id = b.transaction_id and a.customs_message_id = 'TVKR201308301300455' and a.trans_id like '20130917%'