DBA Data[Home] [Help]

APPS.BIM_I_LEAD_FACTS_PKG dependencies on BIS_TERRITORY_HIERARCHIES

Line 662: ,bis_territory_hierarchies T

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'

Line 1203: ,bis_territory_hierarchies T

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'