APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_CROSS_REFERENCES_TL

Line 57: | mtl_cross_references_b and mtl_cross_references_tl

53: |
54: | Modified on 08-Aug-2005 by Kiran Konada
55: | bug# 4539578
56: | In R12, mtl_cross_references datamodel has been changed to
57: | mtl_cross_references_b and mtl_cross_references_tl
58: |
59: |
60: | Modified on 22-Sep-2005 Renga Kannan
61: | Made Code changes for ATG Performance

Line 2833: INSERT INTO mtl_cross_references_tl (

2829:
2830: WriteToLog('Inserted rows into mtl_cross_references_b:: '||sql%rowcount,2);
2831:
2832: FORALL i IN 1..t_cfg_item_id.count
2833: INSERT INTO mtl_cross_references_tl (
2834: last_update_login
2835: ,description
2836: ,creation_date
2837: ,created_by

Line 2862: FROM mtl_cross_references_tl t

2858: AND mtl_cross.organization_id = mtl.organization_id
2859: AND l.language_code = mtl.language
2860: AND l.installed_flag in ('I', 'B')
2861: AND NOT EXISTS (SELECT null
2862: FROM mtl_cross_references_tl t
2863: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2864: AND t.language = l.language_code);
2865:
2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);

Line 2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);

2862: FROM mtl_cross_references_tl t
2863: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2864: AND t.language = l.language_code);
2865:
2866: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);
2867:
2868:
2869: END IF; --t_cross_ref_type.count()
2870: