658: ,x.lead_name Lead_name
659: FROM
660: bim_i_lead_facts_stg X
661: ,bim_i_source_codes A
662: ,bis_territory_hierarchies T
663: WHERE
664: X.source_code_id = A.source_code_id(+)
665: AND T.parent_territory_type(+) = 'AREA'
666: AND T.child_territory_type(+) = 'COUNTRY'
1199: ,x.lead_name lead_name
1200: FROM
1201: bim_i_lead_facts_stg X
1202: ,bim_i_source_codes A
1203: ,bis_territory_hierarchies T
1204: WHERE
1205: X.source_code_id = A.source_code_id(+)
1206: AND T.parent_territory_type(+) = 'AREA'
1207: AND T.child_territory_type(+) = 'COUNTRY'