APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_OBJ_COLUMNS_V

Line 525: cn_obj_columns_v destcol,

521: LOWER(obj.NAME) external_table_name,
522: LOWER(NVL(ext.alias,obj.NAME)) external_table_alias,
523: LOWER(destcol.name) dest_column
524: FROM cn_column_maps cm,
525: cn_obj_columns_v destcol,
526: cn_calc_ext_tables ext,
527: cn_objects obj
528: WHERE cm.table_map_id = x_table_map_id
529: AND cm.expression IS NOT NULL

Line 612: cn_obj_columns_v pkcol,

608: FOR indmap_fk IN
609: (SELECT LOWER(pkcol.name) pkcolumn_name,
610: LOWER(fkcol.name) fkcolumn_name
611: FROM cn_calc_ext_tbl_dtls dtls,
612: cn_obj_columns_v pkcol,
613: cn_obj_columns_v fkcol
614: WHERE dtls.calc_ext_table_id = indmap_rec.calc_ext_table_id
615: AND pkcol.column_id = dtls.external_column_id
616: AND fkcol.column_id = dtls.internal_column_id

Line 613: cn_obj_columns_v fkcol

609: (SELECT LOWER(pkcol.name) pkcolumn_name,
610: LOWER(fkcol.name) fkcolumn_name
611: FROM cn_calc_ext_tbl_dtls dtls,
612: cn_obj_columns_v pkcol,
613: cn_obj_columns_v fkcol
614: WHERE dtls.calc_ext_table_id = indmap_rec.calc_ext_table_id
615: AND pkcol.column_id = dtls.external_column_id
616: AND fkcol.column_id = dtls.internal_column_id
617: AND dtls.org_id = x_org_id