SELECT
TO_CHAR(TBA.FBS_IO_DATE,'YYYY/MM/DD') A1
,TBA.TBA_TBD_NO A2
,TBB.TBB_NAME_S A3
,TBC.TBC_CHAR1 A4
,TBD.TBD_NAME A5
,TBA.TBA_SNS_NAME_SP A6
,TBA.TBA_TORI_KIN A7
,TO_CHAR(TBA.TBA_RPL_DATE,'YYYY/MM/DD') A8
FROM
SNTBATRN TBA
,ZMTBCMST TBC
,CMTBBMST TBB
,CMTBDMST TBD
WHERE
TBA.TBA_KAI_CODE = 'XXX'
AND TBA.TBA_KESHI_KBN = '0'
AND TBA.TBA_TAISYO_KBN IN ('0', '2')
AND TBB_KAI_CODE (+) = 'XXX'
AND TBB_BUN_CODE (+) = 'S001'
AND TBB_START_DATE <= SYSDATE
AND TBB_END_DATE >= SYSDATE
AND TBB.TBB_CODE (+)= TBA.TBA_STN_CODE
AND TBC.TBC_KAI_CODE (+) = 'XXX'
AND TBC.TBC_SUB_KBN (+) = 'SN'
AND TBD.TBD_KAI_CODE (+) = 'XXX'
AND TBD.TBD_CODE (+) = TBA.TBA_SNS_CODE
|