[Home] [Help]
APPS.CSTPOMLD dependencies on BIS_TERRITORY_HIERARCHIES_V
Line 1984: from bis_territory_hierarchies_v bthv
1980: l_stmt_id := 185;
1981: update CST_BIS_MARGIN_SUMMARY cmt
1982: set (AREA_CODE, COUNTRY_NAME) =
1983: (select bthv.PARENT_TERRITORY_CODE, bthv.CHILD_TERRITORY_NAME
1984: from bis_territory_hierarchies_v bthv
1985: where
1986: bthv.CHILD_TERRITORY_CODE = cmt.country_code)
1987: where
1988: cmt.country_code is not null