[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 |
5064: GROUP BY xtag.from_segment_code )
5065: LOOP
5066: -- reset the GT table
5067:
5068: DELETE from gl_accts_map_bsv_gt;
5069:
5070: -- insert the segment value in the GT table
5071:
5072: INSERT INTO gl_accts_map_bsv_gt
5068: DELETE from gl_accts_map_bsv_gt;
5069:
5070: -- insert the segment value in the GT table
5071:
5072: INSERT INTO gl_accts_map_bsv_gt
5073: ( SOURCE_BSV )
5074: SELECT segment
5075: FROM xla_transaction_accts_gt xtag
5076: WHERE xtag.sl_coa_mapping_id = p_gl_coa_mapping_id
5326: , xta.ledger_id ledger_id
5327: , xta.sl_coa_mapping_id sl_coa_mapping_id
5328: , xta.to_segment_code to_segment_code
5329: , gami.target_bsv target_value
5330: FROM gl_accts_map_bsv_gt gami
5331: , xla_transaction_accts_gt xta
5332: WHERE gami.source_bsv = xta.segment
5333: AND xta.from_segment_code = qualifier_rec.qualifier
5334: AND xta.processing_status_code = 'MAP_QUALIFIER'
5440: , xta.ledger_id ledger_id
5441: , xta.sl_coa_mapping_id sl_coa_mapping_id
5442: , xta.to_segment_code to_segment_code
5443: , gami.target_bsv target_value
5444: FROM gl_accts_map_bsv_gt gami
5445: , xla_transaction_accts_gt xta
5446: WHERE gami.source_bsv = xta.segment
5447: AND xta.from_segment_code = qualifier_rec.qualifier
5448: AND xta.processing_status_code = 'MAP_QUALIFIER'