SELECT B.BUSINESS_NUMBER BUSINESS_NUMBER ,B.BUSINESS_NAME BUSINESS_NAME ,B.BUSINESS_ID BUSINESS_ID ,B.BTC_TYPE_CODE BTC_TYPE_CODE ,A.ADDRESS_ID ADDRESS_ID ,A.STREET_NUMBER STREET_NUMBER ,A.DIRCT_CD_DIRECTION_CODE DIRCT_CD_DIRECTION_CODE ,A.STREET_NAME STREET_NAME ,A.STREET_CD_STREET_TYPE_CODE STREET_CD_STREET_TYPE_CODE_COD ,A.ADDR_SC_ADDRESS_SUBTYPE_CODE ADDR_SC_ADDRESS_SUBTYPE_CODE ,A.SUB_NUMBER SUB_NUMBER ,A.CITY CITY ,A.STATE_CD_STATE_CODE STATE_CD_STATE_CODE ,A.ZIP5 ZIP5 ,A.ZIP4 ZIP4 ,BV.DATE_OF_INFO DATE_OF_INFO ,BV.ROLE_CODE ROLE_CODE ,V.VEHICLE_ID VEHICLE_ID ,V.VMA_VEHICLE_MAKE_CODE VMA_VEHICLE_MAKE_CODE ,V.VMO_VEHICLE_MODEL_CODE VMO_VEHICLE_MODEL_CODE ,V.VST_VEHICLE_STYLE_CODE VST_VEHICLE_STYLE_CODE ,V.YEAR YEAR ,V.VIN VIN FROM VEHICLES V ,BUSINESSES B ,BUSINESS_VEHICLES BV ,ADDRESSES A ,BUSINESS_ADDRESSES BAD WHERE V.VEHICLE_ID=BV.VEHICLE_ID AND B.BUSINESS_NUMBER=BV.BUSINESS_NUMBER AND a.address_id (+) = bad.address_id AND b.business_number = bad.business_number (+)