SELECT ITA.ACCESS_ID , CIT.SUB_TYPE_ID , CIT.TRANSACTION_TYPE_ID , CIT.DEFAULT_FLAG , CIT.UPDATE_IB_FLAG FROM CSI_SOURCE_IB_TYPES CIT , JTM_CSI_SOURCE_IB_TYPES_ACC ITA WHERE CIT.SUB_TYPE_ID = ITA.SUB_TYPE_ID AND CIT.TRANSACTION_TYPE_ID = ITA.TRANSACTION_TYPE_ID
SELECT ITA.ACCESS_ID
, CIT.SUB_TYPE_ID
, CIT.TRANSACTION_TYPE_ID
, CIT.DEFAULT_FLAG
, CIT.UPDATE_IB_FLAG
FROM CSI_SOURCE_IB_TYPES CIT
, JTM_CSI_SOURCE_IB_TYPES_ACC ITA
WHERE CIT.SUB_TYPE_ID = ITA.SUB_TYPE_ID
AND CIT.TRANSACTION_TYPE_ID = ITA.TRANSACTION_TYPE_ID
|
|
|