APPS.CN_COLLECTION_AR_GEN dependencies on CN_OBJECTS

Line 41: cn_objects destcol

37: SELECT LOWER(destcol.name) dest_column,
38: cm.expression expression
39: FROM cn_table_maps tm,
40: cn_column_maps cm,
41: cn_objects destcol
42: WHERE tm.mapping_type = 'INV1'
43: AND cm.table_map_id = tm.table_map_id
44: AND cm.expression IS NOT NULL
45: AND cm.destination_column_id = destcol.object_id

Line 400: cn_objects destcol

396: SELECT LOWER(destcol.name) dest_column,
397: cm.expression expression
398: FROM cn_table_maps tm,
399: cn_column_maps cm,
400: cn_objects destcol
401: WHERE tm.mapping_type = 'INV1'
402: AND cm.table_map_id = tm.table_map_id
403: AND cm.expression IS NOT NULL
404: AND cm.destination_column_id = destcol.object_id

Line 574: cn_objects destcol

570: SELECT LOWER(destcol.name) dest_column,
571: cm.expression expression
572: FROM cn_table_maps tm,
573: cn_column_maps cm,
574: cn_objects destcol
575: WHERE tm.mapping_type = 'INV2'
576: AND cm.table_map_id = tm.table_map_id
577: AND cm.expression IS NOT NULL
578: AND cm.destination_column_id = destcol.object_id

Line 781: cn_objects destcol

777: SELECT LOWER(destcol.name) dest_column,
778: cm.expression expression
779: FROM cn_table_maps tm,
780: cn_column_maps cm,
781: cn_objects destcol
782: WHERE tm.mapping_type = 'INV3'
783: AND cm.table_map_id = tm.table_map_id
784: AND cm.expression IS NOT NULL
785: AND cm.destination_column_id = destcol.object_id

Line 1233: cn_objects destcol

1229: SELECT LOWER(destcol.name) dest_column,
1230: ccm.expression
1231: FROM cn_column_maps ccm,
1232: cn_table_maps tm,
1233: cn_objects destcol
1234: WHERE tm.mapping_type = 'AR'
1235: AND ccm.table_map_id = tm.table_map_id
1236: AND (ccm.column_map_id > 0 -- New mappings to Attribute columns
1237: OR ccm.modified = 'Y') -- User has modified a seeded mapping