APPS.CN_COLLECTION_AR_GEN dependencies on CN_COLUMN_MAPS

Line 31: -- This is done by joining cn_obj_columns_v with cn_column_maps.

27: i INTEGER;
28:
29: -- This cursor fetches source and destination column names
30: -- required to insert into the trx headers table.
31: -- This is done by joining cn_obj_columns_v with cn_column_maps.
32: -- It is assumed that each column map has a single level foreign key
33: -- map associated with it.
34:
35:

Line 40: cn_column_maps cm,

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
44: AND cm.expression IS NOT NULL

Line 399: cn_column_maps cm,

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
403: AND cm.expression IS NOT NULL

Line 573: cn_column_maps cm,

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
577: AND cm.expression IS NOT NULL

Line 780: cn_column_maps cm,

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
784: AND cm.expression IS NOT NULL

Line 1231: FROM cn_column_maps ccm,

1227:
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