DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_CROSS_REFERENCES_TL

Line 322: | mtl_cross_references_b and mtl_cross_references_tl

318: |
319: | Modified on 08-Aug-2005 Kiran Konada
320: | bug# 4539578
321: | In R12, mtl_cross_references datamodel has been changed to
322: | mtl_cross_references_b and mtl_cross_references_tl
323: |
324: | Modified on 15-Sep-2005 Renga Kannan
325: | Made Code changes for ATG Performance
326: | Project

Line 7831: INSERT INTO mtl_cross_references_tl (

7827: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_b'||sql%rowcount,2);
7828:
7829: END IF;
7830:
7831: INSERT INTO mtl_cross_references_tl (
7832: last_update_login
7833: ,description
7834: ,creation_date
7835: ,created_by

Line 7860: FROM mtl_cross_references_tl t

7856: AND mtl_cross.organization_id = mtl.organization_id
7857: AND l.language_code = mtl.language
7858: AND l.installed_flag in ('I', 'B')
7859: AND NOT EXISTS (SELECT null
7860: FROM mtl_cross_references_tl t
7861: WHERE t.cross_reference_id = mtl_cross.cross_reference_id
7862: AND t.language = l.language_code);
7863:
7864:

Line 7867: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);

7863:
7864:
7865:
7866: IF PG_DEBUG <> 0 THEN
7867: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);
7868: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);
7869:
7870: END IF;
7871:

Line 7868: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);

7864:
7865:
7866: IF PG_DEBUG <> 0 THEN
7867: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_cross_references_tl',2);
7868: oe_debug_pub.add('Create_Item: ' || '# of inserted rows mtl_cross_references_tl'||sql%rowcount,2);
7869:
7870: END IF;
7871:
7872: