|
|
| |
|
|
| SELECT Z.CRCC_NO,Z.CRCR_CD,Z.TTC_CRC_TYP,Z.SSS_SPPP_TYPE,
Z.CLNT_CRC_NO,Z.M_SF_CD,TO_CHAR (Z.KA_PAL_DCTN_DA, 'YYYYMMDD'),Z.P_S_D_RSN_CD,TO_CHAR
(Z.GUS_DATM, 'YYYYMMDDHH24MISS'),Z.GUS_PSN_NM,TO_CHAR (Z.CHAG_DDA,
'YYYYMMDDHH24MISS'),Z.CHG_POSS,D.CRC_NO,D.KA_ITEM_NM, D.EMKA_CD,D.EMKA_TYP,D.KA_ITEM_CTG_CD,D.TOOL_SPARC_TYP,
D.EMKA_CD,D.EL_SYBL,E.CRC_NO,E.CNTT1,E.CNTT2,E.CNTT3, E.CNTT4,E.CNTT5,E.CNTT6,E.CNTT7,E.CNTT8,E.CNTT9,E.CNTT10,
TO_CHAR (E.CHAG_DDA,'YYYYMMDDHH24MISS'), F.CRC_NO,F.SL_UC, TO_CHAR
(F.CHAG_DDA,'YYYYMMDDHH24MISS'),G.CRC_NO, G.EKA_MODEL_ITEM_NM,TO_CHAR
(G.CHAG_DDA,'YYYYMMDDHH24MISS'), H.CRCC_NO,H.MAP_WWFF_CD,J.CRCR_CD,J.MAP_WWFF_CD,
J.S_MAP_WWFF_CD,K.CRCR_CD,K.MAP_WWFF_CD,K.S_MAP_WWFF_CD, L.KA_ITEM_NM,L.EMKA_TYP,L.KA_ITEM_CTG_CD,L.EMKA_CD,
L.TOOL_SPARC_TYP,L.EL_SYBL,M.EMKA_CD,N.XXCTNT1,N.XXCTNT2, N.XXCTNT3,N.XXCTNT4,N.XXCTNT5,O.XXCTNT1,O.XXCTNT2,
O.XXCTNT3,O.XXCTNT4,O.XXCTNT5,Q.DAT_COV_CNT,R.DAT_COV_CNT, S.DAT_COV_CNT,T.DAT_COV_CNT,Z.PKG_QUE,W.MODEL_ITEM_NO,
W.EKA_MODEL_ITEM_NM,Y.DAT_COV_CNT FROM (SELECT A.CRCC_NO, A.CRCR_CD,A.TTC_CRC_TYP,
A.SSS_SPPP_TYPE,A.CLNT_CRC_NO, A.M_SF_CD,B.KA_PAL_DVSN_CD,C.CRC_NO,C.PALL_DAL_NO,
C.ONE_CD,C.TSOP_STYL_CD,C.C_CRC_DAL_NO,C.SHP_KA_ITEM_NO, C.FOR_UC,C.L_KA_CRC_QUE,C.LPRD_NM1,C.PLAN_QUE1,C.LPRD_NM2,
C.PLAN_QUE2,C.MODEL_ITEM_NO,C.CLIKA_NO,C.C_O_E_CRC_NO, C.CHAG_DDA,C.CHG_POSS,C.PKG_QUE
FROM CRCHD A,CRCPL B, CRCIM C WHERE B.CRCC_NO = A.CRCC_NO AND
C.CRC_NO = B.CRC_NO AND A.CRCC_NO ='DO15411') Z, CRCDP D,DEARS
E, CRCSP F,CRCMI G,CRCTT H,MANOB J,MANOB K,VSOPN L,SPOOL M,
LLHAP N,LLHAP O,DACOV Q,DACOV R, DACOV S,DACOV T,MODEL W, DACOV
Y WHERE J.S_CHAC_DKA_CD (+) ='2' AND J.CRCR_CD (+) = Z.CRCR_CD
AND J.TTC_CRC_TYP (+) = Z.TTC_CRC_TYP AND J.ONE_CD (+) = Z.ONE_CD
AND J.TSOP_STYL_CD (+) = Z.TSOP_STYL_CD AND J.M_SF_CD (+) =
Z.M_SF_CD AND K.S_CHAC_DKA_CD (+) ='2' AND K.CRCR_CD (+) = Z.CRCR_CD
AND K.TTC_CRC_TYP (+) = Z.TTC_CRC_TYP AND K.ONE_CD (+) = Z.ONE_CD
AND K.TSOP_STYL_CD (+) ='*' AND K.M_SF_CD (+) = Z.M_SF_CD AND
D.CRC_NO (+) = Z.CRC_NO AND D.PALL_DAL_NO (+) = Z.PALL_DAL_NO
AND E.CRC_NO (+) = Z.CRC_NO AND E.PALL_DAL_NO (+) = Z.PALL_DAL_NO
AND F.CRC_NO (+) = Z.CRC_NO AND F.PALL_DAL_NO (+) = Z.PALL_DAL_NO
AND G.CRC_NO (+) = Z.CRC_NO AND G.PALL_DAL_NO (+) = Z.PALL_DAL_NO
AND H.CRCC_NO (+) = Z.CRCC_NO AND H.ONE_CD (+) = Z.ONE_CD AND
H.TSOP_STYL_CD (+) = Z.TSOP_STYL_CD AND L.KA_ITEM_NO (+) = Z.SHP_KA_ITEM_NO
AND TO_CHAR (L.APLAY_SDA (+),'YYYYMMDD') <='19640615' AND TO_CHAR
(L.APLAY_EDA (+),'YYYYMMDD') >='19640615' AND M.KA_ITEM_NO (+)
= Z.SHP_KA_ITEM_NO AND M.KA_PAL_DVSN_CD (+) = Z.KA_PAL_DVSN_CD
AND TO_CHAR (M.APLAY_SDA (+),'YYYYMMDD') <='19640615' AND TO_CHAR
(M.APLAY_EDA (+),'YYYYMMDD') >='19640615' AND N.KA_ITEM_NO (+)
= Z.SHP_KA_ITEM_NO AND N.KA_PAL_DVSN_CD (+) ='00000000' AND
TO_CHAR (N.APLAY_SDA (+), 'YYYYMMDD') <='19640615' AND TO_CHAR
(N.APLAY_EDA (+),'YYYYMMDD') >= '19640615' AND O.KA_ITEM_NO
(+) = Z.SHP_KA_ITEM_NO AND O.KA_PAL_DVSN_CD (+) = Z.KA_PAL_DVSN_CD
AND TO_CHAR (O.APLAY_SDA (+),'YYYYMMDD') <='19640615' AND TO_CHAR
(O.APLAY_EDA (+),'YYYYMMDD') >='19640615' AND Q.BSNS_CLSS_CD
(+) ='CD1' AND Q.DAT_KD_CD (+) ='POPS' AND Q.DDA_COV_KY1 (+)
= J.MAP_WWFF_CD AND TO_CHAR (Q.APLAY_SDA (+),'YYYYMMDD') <='19640615'
AND TO_CHAR (Q.APLAY_EDA (+),'YYYYMMDD') >='19640615' AND R.BSNS_CLSS_CD
(+) ='CD1' AND R.DAT_KD_CD (+) ='POPS' AND R.DDA_COV_KY1 (+)
= J.S_MAP_WWFF_CD AND TO_CHAR (R.APLAY_SDA (+), 'YYYYMMDD')
<='19640615' AND TO_CHAR (R.APLAY_EDA (+),'YYYYMMDD') >='19640615'
AND S.BSNS_CLSS_CD (+) = 'CD1' AND S.DAT_KD_CD (+) ='POPS' AND
S.DDA_COV_KY1 (+) = K.MAP_WWFF_CD AND TO_CHAR (S.APLAY_SDA (+),'YYYYMMDD')
<='19640615' AND TO_CHAR (S.APLAY_EDA (+),'YYYYMMDD') >= '19640615'
AND T.BSNS_CLSS_CD (+) ='CD1' AND T.DAT_KD_CD (+) ='POPS' AND
T.DDA_COV_KY1 (+) = K.S_MAP_WWFF_CD AND TO_CHAR (T.APLAY_SDA
(+), 'YYYYMMDD') <='19640615' AND TO_CHAR (T.APLAY_EDA (+),'YYYYMMDD')
>='19640615' AND W.MODEL_ITEM_NO (+) = Z.MODEL_ITEM_NO AND W.KA_PAL_DVSN_CD
(+) = Z.KA_PAL_DVSN_CD AND TO_CHAR (W.APLAY_SDA (+),'YYYYMMDD')
<='19640615' AND TO_CHAR (W.APLAY_EDA (+),'YYYYMMDD') >='19640615'
AND Y.BSNS_CLSS_CD (+) ='CD1'AND Y.DAT_KD_CD (+) ='DEKA' AND
Y.DDA_COV_KY1 (+) = Z.KA_PAL_DVSN_CD AND TO_CHAR (Y.APLAY_SDA
(+),'YYYYMMDD') <='19640615' AND TO_CHAR (Y.APLAY_EDA (+),'YYYYMMDD')
>='19640615' ORDER BY Z.CRC_NO,Z.PALL_DAL_NO |
|
|
SELECT
Z.CRCC_NO
, Z.CRCR_CD
, Z.TTC_CRC_TYP
, Z.SSS_SPPP_TYPE
, Z.CLNT_CRC_NO
, Z.M_SF_CD
, TO_CHAR ( Z.KA_PAL_DCTN_DA , 'YYYYMMDD' )
, Z.P_S_D_RSN_CD
, TO_CHAR ( Z.GUS_DATM , 'YYYYMMDDHH24MISS' )
, Z.GUS_PSN_NM
, TO_CHAR ( Z.CHAG_DDA , 'YYYYMMDDHH24MISS' )
, Z.CHG_POSS
, D.CRC_NO
, D.KA_ITEM_NM
, D.EMKA_CD
, D.EMKA_TYP
, D.KA_ITEM_CTG_CD
, D.TOOL_SPARC_TYP
, D.EMKA_CD
, D.EL_SYBL
, E.CRC_NO
, E.CNTT1
, E.CNTT2
, E.CNTT3
, E.CNTT4
, E.CNTT5
, E.CNTT6
, E.CNTT7
, E.CNTT8
, E.CNTT9
, E.CNTT10
, TO_CHAR ( E.CHAG_DDA , 'YYYYMMDDHH24MISS' )
, F.CRC_NO
, F.SL_UC
, TO_CHAR ( F.CHAG_DDA , 'YYYYMMDDHH24MISS' )
, G.CRC_NO
, G.EKA_MODEL_ITEM_NM
, TO_CHAR ( G.CHAG_DDA , 'YYYYMMDDHH24MISS' )
, H.CRCC_NO
, H.MAP_WWFF_CD
, J.CRCR_CD
, J.MAP_WWFF_CD
, J.S_MAP_WWFF_CD
, K.CRCR_CD
, K.MAP_WWFF_CD
, K.S_MAP_WWFF_CD
, L.KA_ITEM_NM
, L.EMKA_TYP
, L.KA_ITEM_CTG_CD
, L.EMKA_CD
, L.TOOL_SPARC_TYP
, L.EL_SYBL
, M.EMKA_CD
, N.XXCTNT1
, N.XXCTNT2
, N.XXCTNT3
, N.XXCTNT4
, N.XXCTNT5
, O.XXCTNT1
, O.XXCTNT2
, O.XXCTNT3
, O.XXCTNT4
, O.XXCTNT5
, Q.DAT_COV_CNT
, R.DAT_COV_CNT
, S.DAT_COV_CNT
, T.DAT_COV_CNT
, Z.PKG_QUE
, W.MODEL_ITEM_NO
, W.EKA_MODEL_ITEM_NM
, Y.DAT_COV_CNT
FROM
(
SELECT
A.CRCC_NO
, A.CRCR_CD
, A.TTC_CRC_TYP
, A.SSS_SPPP_TYPE
, A.CLNT_CRC_NO
, A.M_SF_CD
, B.KA_PAL_DVSN_CD
, C.CRC_NO
, C.PALL_DAL_NO
, C.ONE_CD
, C.TSOP_STYL_CD
, C.C_CRC_DAL_NO
, C.SHP_KA_ITEM_NO
, C.FOR_UC
, C.L_KA_CRC_QUE
, C.LPRD_NM1
, C.PLAN_QUE1
, C.LPRD_NM2
, C.PLAN_QUE2
, C.MODEL_ITEM_NO
, C.CLIKA_NO
, C.C_O_E_CRC_NO
, C.CHAG_DDA
, C.CHG_POSS
, C.PKG_QUE
FROM
CRCHD A
, CRCPL B
, CRCIM C
WHERE
B.CRCC_NO = A.CRCC_NO
AND C.CRC_NO = B.CRC_NO
AND A.CRCC_NO ='DO15411' ) Z
, CRCDP D
, DEARS E
, CRCSP F
, CRCMI G
, CRCTT H
, MANOB J
, MANOB K
, VSOPN L
, SPOOL M
, LLHAP N
, LLHAP O
, DACOV Q
, DACOV R
, DACOV S
, DACOV T
, MODEL W
, DACOV Y
WHERE
J.S_CHAC_DKA_CD ( + ) ='2'
AND J.CRCR_CD ( + ) = Z.CRCR_CD
AND J.TTC_CRC_TYP ( + ) = Z.TTC_CRC_TYP
AND J.ONE_CD ( + ) = Z.ONE_CD
AND J.TSOP_STYL_CD ( + ) = Z.TSOP_STYL_CD
AND J.M_SF_CD ( + ) = Z.M_SF_CD
AND K.S_CHAC_DKA_CD ( + ) ='2'
AND K.CRCR_CD ( + ) = Z.CRCR_CD
AND K.TTC_CRC_TYP ( + ) = Z.TTC_CRC_TYP
AND K.ONE_CD ( + ) = Z.ONE_CD
AND K.TSOP_STYL_CD ( + ) ='*'
AND K.M_SF_CD ( + ) = Z.M_SF_CD
AND D.CRC_NO ( + ) = Z.CRC_NO
AND D.PALL_DAL_NO ( + ) = Z.PALL_DAL_NO
AND E.CRC_NO ( + ) = Z.CRC_NO
AND E.PALL_DAL_NO ( + ) = Z.PALL_DAL_NO
AND F.CRC_NO ( + ) = Z.CRC_NO
AND F.PALL_DAL_NO ( + ) = Z.PALL_DAL_NO
AND G.CRC_NO ( + ) = Z.CRC_NO
AND G.PALL_DAL_NO ( + ) = Z.PALL_DAL_NO
AND H.CRCC_NO ( + ) = Z.CRCC_NO
AND H.ONE_CD ( + ) = Z.ONE_CD
AND H.TSOP_STYL_CD ( + ) = Z.TSOP_STYL_CD
AND L.KA_ITEM_NO ( + ) = Z.SHP_KA_ITEM_NO
AND TO_CHAR ( L.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( L.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND M.KA_ITEM_NO ( + ) = Z.SHP_KA_ITEM_NO
AND M.KA_PAL_DVSN_CD ( + ) = Z.KA_PAL_DVSN_CD
AND TO_CHAR ( M.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( M.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND N.KA_ITEM_NO ( + ) = Z.SHP_KA_ITEM_NO
AND N.KA_PAL_DVSN_CD ( + ) ='00000000'
AND TO_CHAR ( N.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( N.APLAY_EDA ( + ) , 'YYYYMMDD' ) >= '19640615'
AND O.KA_ITEM_NO ( + ) = Z.SHP_KA_ITEM_NO
AND O.KA_PAL_DVSN_CD ( + ) = Z.KA_PAL_DVSN_CD
AND TO_CHAR ( O.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( O.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND Q.BSNS_CLSS_CD ( + ) ='CD1'
AND Q.DAT_KD_CD ( + ) ='POPS'
AND Q.DDA_COV_KY1 ( + ) = J.MAP_WWFF_CD
AND TO_CHAR ( Q.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( Q.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND R.BSNS_CLSS_CD ( + ) ='CD1'
AND R.DAT_KD_CD ( + ) ='POPS'
AND R.DDA_COV_KY1 ( + ) = J.S_MAP_WWFF_CD
AND TO_CHAR ( R.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( R.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND S.BSNS_CLSS_CD ( + ) = 'CD1'
AND S.DAT_KD_CD ( + ) ='POPS'
AND S.DDA_COV_KY1 ( + ) = K.MAP_WWFF_CD
AND TO_CHAR ( S.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( S.APLAY_EDA ( + ) , 'YYYYMMDD' ) >= '19640615'
AND T.BSNS_CLSS_CD ( + ) ='CD1'
AND T.DAT_KD_CD ( + ) ='POPS'
AND T.DDA_COV_KY1 ( + ) = K.S_MAP_WWFF_CD
AND TO_CHAR ( T.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( T.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND W.MODEL_ITEM_NO ( + ) = Z.MODEL_ITEM_NO
AND W.KA_PAL_DVSN_CD ( + ) = Z.KA_PAL_DVSN_CD
AND TO_CHAR ( W.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( W.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
AND Y.BSNS_CLSS_CD ( + ) ='CD1'AND Y.DAT_KD_CD ( + ) ='DEKA'
AND Y.DDA_COV_KY1 ( + ) = Z.KA_PAL_DVSN_CD
AND TO_CHAR ( Y.APLAY_SDA ( + ) , 'YYYYMMDD' ) <='19640615'
AND TO_CHAR ( Y.APLAY_EDA ( + ) , 'YYYYMMDD' ) >='19640615'
ORDER BY
Z.CRC_NO
, Z.PALL_DAL_NO |
|
Copyright(C) 2000-2008 IceProbe, All rights reserved.
|
|
