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 2664: INSERT INTO mtl_cross_references_tl (

2660:
2661: WriteToLog('Inserted rows into mtl_cross_references_b:: '||sql%rowcount,2);
2662:
2663: FORALL i IN 1..t_cfg_item_id.count
2664: INSERT INTO mtl_cross_references_tl (
2665: last_update_login
2666: ,description
2667: ,creation_date
2668: ,created_by

Line 2693: FROM mtl_cross_references_tl t

2689: AND mtl_cross.organization_id = mtl.organization_id
2690: AND l.language_code = mtl.language
2691: AND l.installed_flag in ('I', 'B')
2692: AND NOT EXISTS (SELECT null
2693: FROM mtl_cross_references_tl t
2694: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2695: AND t.language = l.language_code);
2696:
2697: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);

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

2693: FROM mtl_cross_references_tl t
2694: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
2695: AND t.language = l.language_code);
2696:
2697: WriteToLog('Inserted rows into mtl_cross_references_tl:: '||sql%rowcount,2);
2698:
2699:
2700: END IF; --t_cross_ref_type.count()
2701: