| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIJ010005.ReadyToDeliverCoils.Select" desc=" 查询运送指示信息 " fetchSize="10">
- <![CDATA[
- SELECT A.*
- ---- TBA01_ORD_COMM
- , B.RCVORD_TP, B.CUST_CD, B.ORDCUST_CD
- , B.PRDNM_CD, B.PAYCDT_TP, B.SALE_CHR_CD
- , B.MS_MARK_TP, B.MS_SPEC_ABBSYM, B.MS_SPEC_STL_GRD
- , B.MS_CUST_CD, B.MS_ORDCUST_CD, B.MS_MARK_UNIT
- , B.ORD_ACT_DTIME, B.ORD_ACTBY_CD
- --, B.ORD_UDT_YN, B.ORD_UDT_DTIME, B.ORD_UDTBY_CD, B.ORD_UDTRSN_TP
- --, B.ORD_CNC_YN, B.ORD_CNC_DTIME, B.ORD_CNCBY_CD, B.ORD_CNCRSN_TP
- , B.ORD_CMT_YN, B.ORD_CMT_DTIME, B.ORD_CMTBY_CD
- , B.CUST_SPREQ_TP, B.CUST_SPREQ_FILE, B.CUST_SPREQ_DESC, B.CONTRACT_NO, B.ORD_NO_PROG_CD
- , B.CONT_AMT
- ---- TBA01_ORD_LINE
- , B.STKSALE_TP, B.SPEC_ABBSYM, B.ORD_USE_TP, B.CUST_STL_GRD, B.SPEC_STL_GRD, B.FAC_STL_GRD, B.DDC_STL_GRD
- , B.ORD_DEVLMT_DATE, B.CMT_DLIV_DEVLMT_DATE, B.EMGMTR_MNG_YN, B.CUST_SPEC_NO, B.LST_QDSN_DATE, B.ORD_SEQ_PROG_CD
- , B.QDSN_ERR_CD, B.ORD_THK, B.ORD_WTH, B.ORD_LEN, B.ORD_WGT, B.ORD_CNT, B.WGT_ACVAL_MIN, B.WGT_ACVAL_MAX
- , B.WGT_DSRULE_CD, B.ORD_INDIA, B.ORD_OUTDIA, B.PROD_WGT_MIN, B.PROD_WGT_MAX
- , B.SCARFING_PROC_YN, B.GRIND_PROC_YN, B.HCR_CLF, B.EDGE_PROC_YN, B.SPM_PROC_YN, B.UST_CD, B.SHL_PROC_YN, B.SFC_PROC_YN, B.BTWSHT_INS_YN
- , B.MK_CONTENT, B.LBL_MRKMTH_TP, B.PAKMTH_TP, B.PAKMTH_XBIND, B.PAKMTH_YBIND, B.PRDC_MNF_TERM
- , B.ORD_END_YN, B.ORD_END_DATE, B.ORD_ENDBY_CD
- , B.ORD_UDT_YN, B.ORD_UDT_DTIME, B.ORD_UDTBY_CD, B.ORD_UDTRSN_TP
- , B.ORD_CNC_YN, B.ORD_CNC_DTIME, B.ORD_CNCBY_CD, B.ORD_CNCRSN_TP
- , B.SHIP_END_YN, B.SHIP_END_DATE, B.SHIP_ENDBY_CD
- , B.EXAMORG_CD
- , B.DLIV_TP, B.GET_ON_PCD, B.DEST_PCD, B.EXLV_LINE_CD, B.GET_OFF_PCD, B.BY_SEA_YN, B.DEPARTURE_CD, B.ARRIVAL_CD
- , B.KEEPWARM_YN, B.EACHLOT_YN, B.DLIV_AMT, B.SALES_AMT, B.AMT_ACVAL_MIN, B.AMT_ACVAL_MAX, B.ORD_AMT, B.TRTMTH_TP
- FROM TBH02_COIL_COMM A
- ,(SELECT X.*
- , Y.RCVORD_TP, Y.CUST_CD, Y.ORDCUST_CD
- , Y.PRDNM_CD, Y.PAYCDT_TP, Y.SALE_CHR_CD
- , Y.MS_MARK_TP, Y.MS_SPEC_ABBSYM, Y.MS_SPEC_STL_GRD
- , Y.MS_CUST_CD, Y.MS_ORDCUST_CD, Y.MS_MARK_UNIT
- , Y.ORD_ACT_DTIME, Y.ORD_ACTBY_CD
- --, Y.ORD_UDT_YN, Y.ORD_UDT_DTIME, Y.ORD_UDTBY_CD, Y.ORD_UDTRSN_TP
- --, Y.ORD_CNC_YN, Y.ORD_CNC_DTIME, Y.ORD_CNCBY_CD, Y.ORD_CNCRSN_TP
- , Y.ORD_CMT_YN, Y.ORD_CMT_DTIME, Y.ORD_CMTBY_CD
- , Y.CUST_SPREQ_TP, Y.CUST_SPREQ_FILE, Y.CUST_SPREQ_DESC, Y.CONTRACT_NO, Y.ORD_NO_PROG_CD
- , Y.CONT_AMT
- FROM TBA01_ORD_LINE X, TBA01_ORD_COMM Y
- WHERE 1 = 1
- AND X.ORD_NO = Y.ORD_NO(+)
- AND X.ORD_DEVLMT_DATE BETWEEN NVL(:1,'00000101') AND NVL(:2,'99991231')) B
- WHERE 1 = 1
- AND A.ORD_NO = B.ORD_NO(+)
- AND A.ORD_SEQ = B.ORD_SEQ(+)
- AND A.CUR_PROG_CD = 'SFA'
- AND A.COIL_STAT = '2'
- AND A.ORD_NO LIKE :3||'%'
- AND A.ORD_SEQ LIKE :4||'%'
- ]]>
- </query>
- </queryMap>
|
