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.CNDISL_SLICE_ATTRIBUTES_PKG dependencies on CN_OBJ_COLUMNS_V

Line 39: FROM cn_obj_columns_v col

35: BEGIN
36:
37: SELECT col.name
38: INTO X_column_name
39: FROM cn_obj_columns_v col
40: WHERE col.column_id = X_source_column_id;
41:
42: SELECT name
43: INTO X_dest_column_name

Line 44: FROM cn_obj_columns_v

40: WHERE col.column_id = X_source_column_id;
41:
42: SELECT name
43: INTO X_dest_column_name
44: FROM cn_obj_columns_v
45: WHERE column_id = X_dest_column_id;
46:
47: END Populate_Fields;
48:

Line 85: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

81: X_group_by_flag,
82: X_destination_column_id,
83: X_aggregate_function);
84:
85: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
86: status, repository_id, table_id, data_length,
87: data_type, nullable, primary_key, position,
88: data_scale, column_type, object_type)
89: (SELECT X_destination_column_id, X_column_name, 'N',

Line 93: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

89: (SELECT X_destination_column_id, X_column_name, 'N',
90: 'V', X_repository_id, X_table_id, data_length,
91: data_type, nullable, 'N', position,
92: data_scale, column_type, 'COL'
93: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
94:
95: -- Temp. slice table definition --
96:
97: INSERT INTO cn_column_maps ( table_map_id,

Line 109: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

105: X_group_by_flag,
106: X_tmp_dest_column_id,
107: X_aggregate_function);
108:
109: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
110: status, repository_id, table_id, data_length,
111: data_type, nullable, primary_key, position,
112: data_scale, column_type, object_type)
113: (SELECT X_tmp_dest_column_id, X_column_name, 'N',

Line 117: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

113: (SELECT X_tmp_dest_column_id, X_column_name, 'N',
114: 'V', X_repository_id, X_tmp_table_id, data_length,
115: data_type, nullable, 'N', position,
116: data_scale, column_type, 'COL'
117: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
118:
119: -- Rollup table definition --
120:
121: INSERT INTO cn_column_maps ( table_map_id,

Line 133: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,

129: X_group_by_flag,
130: X_rup_dest_column_id,
131: X_aggregate_function);
132:
133: INSERT INTO cn_obj_columns_v (column_id, name, dependency_map_complete,
134: status, repository_id, table_id, data_length,
135: data_type, nullable, primary_key, position,
136: data_scale, column_type, object_type)
137: (SELECT X_rup_dest_column_id, X_column_name, 'N',

Line 141: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);

137: (SELECT X_rup_dest_column_id, X_column_name, 'N',
138: 'V', X_repository_id, X_rup_table_id, data_length,
139: data_type, nullable, 'N', position,
140: data_scale, column_type, 'COL'
141: FROM cn_obj_columns_v WHERE column_id = X_source_column_id);
142:
143: END Insert_Row;
144:
145: -- -----------------------------------------------------------

Line 157: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;

153:
154: BEGIN
155:
156: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
157: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
158:
159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
161:

Line 160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;

156: DELETE cn_column_maps WHERE column_map_id = X_column_map_id;
157: DELETE cn_obj_columns_v WHERE column_id = X_destination_column_id;
158:
159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
161:
162: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
163: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
164:

Line 163: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;

159: DELETE cn_column_maps WHERE column_map_id = X_tmp_column_map_id;
160: DELETE cn_obj_columns_v WHERE column_id = X_tmp_dest_column_id;
161:
162: DELETE cn_column_maps WHERE column_map_id = X_rup_column_map_id;
163: DELETE cn_obj_columns_v WHERE column_id = X_rup_dest_column_id;
164:
165: END Delete_Row;
166:
167: -- -----------------------------------------------------------