DBA Data[Home] [Help]

APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_OBJ_COLUMNS_V

Line 616: cn_obj_columns_v destcol,

612: LOWER(NVL(ext.alias,obj.NAME)) external_table_alias,
613: LOWER(destcol.name) dest_column
614: FROM
615: cn_column_maps cm,
616: cn_obj_columns_v destcol,
617: cn_calc_ext_tables ext,
618: cn_objects obj
619: WHERE
620: cm.table_map_id = x_table_map_id

Line 711: cn_obj_columns_v pkcol,

707: FOR indmap_fk IN
708: (SELECT LOWER(pkcol.name) pkcolumn_name,
709: LOWER(fkcol.name) fkcolumn_name
710: FROM cn_calc_ext_tbl_dtls dtls,
711: cn_obj_columns_v pkcol,
712: cn_obj_columns_v fkcol
713: WHERE dtls.calc_ext_table_id = indmap_rec.calc_ext_table_id
714: AND pkcol.column_id = dtls.external_column_id
715: AND fkcol.column_id = dtls.internal_column_id

Line 712: cn_obj_columns_v fkcol

708: (SELECT LOWER(pkcol.name) pkcolumn_name,
709: LOWER(fkcol.name) fkcolumn_name
710: FROM cn_calc_ext_tbl_dtls dtls,
711: cn_obj_columns_v pkcol,
712: cn_obj_columns_v fkcol
713: WHERE dtls.calc_ext_table_id = indmap_rec.calc_ext_table_id
714: AND pkcol.column_id = dtls.external_column_id
715: AND fkcol.column_id = dtls.internal_column_id
716: AND dtls.org_id = x_org_id