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 9351: insert into mtl_item_revisions_tl (

9347: stmtnum := 3;
9348:
9349:
9350: --sql_stmt :=
9351: insert into mtl_item_revisions_tl (
9352: inventory_item_id,
9353: organization_id,
9354: revision_id,
9355: language,

Line 9395: from mtl_item_revisions_tl t

9391: and mr.inventory_item_id = pConfigId --3338108
9392: and mr.organization_id = mp1.organization_id --3338108
9393: and NOT EXISTS
9394: (select NULL
9395: from mtl_item_revisions_tl t
9396: where t.inventory_item_id = pConfigId
9397: and t.organization_id = mp1.organization_id
9398: and t.revision_id = mr.revision_id --3338108
9399: and t.language = l.language_code );