SQL: SELECT d.tm_number ,d.ir_number, d.journal_id,d.trade_mark_type_code as tm_word_image ,d.type_of_mark_code as tm_type ,d.lodgement_date ,d.divisional_date ,d.divisional_number ,d.priority_country_code, d.priority_date ,d.priority_number ,c.name_title ,c.name_prefix, c.last_name_or_company_name ,c.company_jurisdiction ,c.acn_or_arbn ,c.address_line_1 as addr1, c.address_line_2 as addr2 ,c.address_line_3 as addr3, c.address_line_4 as addr4 ,c.suburb_name ,c.aus_state_code ,c.postal_code ,c.country_code ,d.address_for_service_text as afs ,d.scent_mark_ind ,d.colour_mark_ind ,d.shape_mark_ind ,d.sound_mark_ind, d.trade_mark_desc ,e.endorsement_text FROM EJTM.ejtm_tm_details d ,EJTM.ejtm_customer_trade_marks ct ,EJTM.ejtm_customer_details c ,EJTM.ejtm_tm_endorsements e ,ejtm.ejtm_journals j WHERE (j.journal_id=d.JOURNAL_ID AND d.TM_NUMBER IN (361258)) AND j.journal_publication_date <= sysdate AND d.tm_number = ct.tm_number AND d.tm_number = e.tm_number (+) AND d.journal_id = ct.journal_id AND d.journal_id = e.journal_id (+) AND d.journal_id = c.journal_id AND d.journal_id = ct.journal_id AND ct.customer_number = c.customer_number ORDER BY d.journal_id, d.tm_number
|