[Home] [Help]
69: | maintain two ccids in line table |
70: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
71: | 11-APR-2005 K.Boussema Reviewed the code to don't process Dummy lines |
72: | 21-APR-2005 Shishir J. Renamed gl_accounts_map_bsv_int_gt to |
73: | gl_accts_map_bsv_gt |
74: | 19-MAI-2005 K.Boussema Reviewed cache_combination_id to fix bug4304098 |
75: | 23-MAY-2005 W.Chan Fix bug4388150 in create_ccid |
76: | 08-Aug-2005 W.Chan Fix bug4542460 in map_ccid |
77: | 19-Aug-2005 W.Chan Fix bug4564062 in map_ccid |
5082: GROUP BY xtag.from_segment_code )
5083: LOOP
5084: -- reset the GT table
5085:
5086: DELETE from gl_accts_map_bsv_gt;
5087:
5088: -- insert the segment value in the GT table
5089:
5090: INSERT INTO gl_accts_map_bsv_gt
5086: DELETE from gl_accts_map_bsv_gt;
5087:
5088: -- insert the segment value in the GT table
5089:
5090: INSERT INTO gl_accts_map_bsv_gt
5091: ( SOURCE_BSV )
5092: SELECT segment
5093: FROM xla_transaction_accts_gt xtag
5094: WHERE xtag.sl_coa_mapping_id = p_gl_coa_mapping_id
5344: , xta.ledger_id ledger_id
5345: , xta.sl_coa_mapping_id sl_coa_mapping_id
5346: , xta.to_segment_code to_segment_code
5347: , gami.target_bsv target_value
5348: FROM gl_accts_map_bsv_gt gami
5349: , xla_transaction_accts_gt xta
5350: WHERE gami.source_bsv = xta.segment
5351: AND xta.from_segment_code = qualifier_rec.qualifier
5352: AND xta.processing_status_code = 'MAP_QUALIFIER'
5458: , xta.ledger_id ledger_id
5459: , xta.sl_coa_mapping_id sl_coa_mapping_id
5460: , xta.to_segment_code to_segment_code
5461: , gami.target_bsv target_value
5462: FROM gl_accts_map_bsv_gt gami
5463: , xla_transaction_accts_gt xta
5464: WHERE gami.source_bsv = xta.segment
5465: AND xta.from_segment_code = qualifier_rec.qualifier
5466: AND xta.processing_status_code = 'MAP_QUALIFIER'