eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CNDIHY_HIERARCHY_PKG dependencies on CN_OBJ_COLUMNS_V

Line 160: cn_obj_columns_v col,

156: 'WHERE dim_hierarchy_id = :periods.dim_hierarchy_id '||
157: 'ORDER BY 1'
158: INTO X_select_clause
159: FROM cn_obj_tables_v tab,
160: cn_obj_columns_v col,
161: cn_obj_columns_v pk
162: WHERE tab.table_id = col.table_id
163: AND tab.table_id = pk.table_id
164: AND pk.dimension_id = X_dimension_id

Line 161: cn_obj_columns_v pk

157: 'ORDER BY 1'
158: INTO X_select_clause
159: FROM cn_obj_tables_v tab,
160: cn_obj_columns_v col,
161: cn_obj_columns_v pk
162: WHERE tab.table_id = col.table_id
163: AND tab.table_id = pk.table_id
164: AND pk.dimension_id = X_dimension_id
165: AND pk.primary_key = 'Y'

Line 178: cn_obj_columns_v col,

174: ' NAME, '||pk.name||
175: ' VALUE_ID FROM '||tab.name
176: INTO X_select_clause
177: FROM cn_obj_tables_v tab,
178: cn_obj_columns_v col,
179: cn_obj_columns_v pk
180: WHERE tab.table_id = col.table_id
181: AND tab.table_id = pk.table_id
182: AND pk.dimension_id = X_dimension_id

Line 179: cn_obj_columns_v pk

175: ' VALUE_ID FROM '||tab.name
176: INTO X_select_clause
177: FROM cn_obj_tables_v tab,
178: cn_obj_columns_v col,
179: cn_obj_columns_v pk
180: WHERE tab.table_id = col.table_id
181: AND tab.table_id = pk.table_id
182: AND pk.dimension_id = X_dimension_id
183: AND pk.primary_key = 'Y'