APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_REVISIONS_TL

Line 256: | b) where condition for insert into mtl_item_revisions_tl

252: | As items team has decide to create a
253: | unique index on it, the revision_id needs
254: | to be different in each org
255: |
256: | b) where condition for insert into mtl_item_revisions_tl
257: | is also changed to get the corresponding revisionId
258: | info from table mtl_item_revisions_b table
259: |
260: | c) fixed by sawant

Line 9050: insert into mtl_item_revisions_tl (

9046: stmtnum := 3;
9047:
9048:
9049: --sql_stmt :=
9050: insert into mtl_item_revisions_tl (
9051: inventory_item_id,
9052: organization_id,
9053: revision_id,
9054: language,

Line 9094: from mtl_item_revisions_tl t

9090: and mr.inventory_item_id = pConfigId --3338108
9091: and mr.organization_id = mp1.organization_id --3338108
9092: and NOT EXISTS
9093: (select NULL
9094: from mtl_item_revisions_tl t
9095: where t.inventory_item_id = pConfigId
9096: and t.organization_id = mp1.organization_id
9097: and t.revision_id = mr.revision_id --3338108
9098: and t.language = l.language_code );