APPS.CN_COLLECTION_AR_GEN dependencies on CN_TABLE_MAPS

Line 39: FROM cn_table_maps tm,

35:
36: CURSOR header_direct_maps IS
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

Line 398: FROM cn_table_maps tm,

394:
395: CURSOR header_direct_maps IS
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

Line 572: FROM cn_table_maps tm,

568: -- Declare cursor for inserting into the trx lines table
569: CURSOR lines_direct_maps IS
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

Line 779: FROM cn_table_maps tm,

775: -- Declare cursor for inserting into the sales_lines table
776: CURSOR sales_lines_direct_maps IS
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

Line 1232: cn_table_maps tm,

1228: CURSOR header_direct_maps IS
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