[Home] [Help]
22: | 03-15-2004 Kiran Konada
23: | 3504153
24: |
25: | Propagated fix 3340844 from CTOCITMB
26: | Populate value revision_label into mtl_item_revisions_b
27: | removed the join to distinct and join on bcso
28: |
29: | Propagated fix 3338108 from CTOCITMB.pls
30: | Populate revision_id by making a join to
27: | removed the join to distinct and join on bcso
28: |
29: | Propagated fix 3338108 from CTOCITMB.pls
30: | Populate revision_id by making a join to
31: | mtl_item_revisions_b
32: |
33: |
34: | 04-19-2004 Sushant Sawant
35: | Fixed bug 3576040
1250:
1251: /*-------------------------------------------+
1252: Insert Item revision information
1253: Till Patchset I, this information was inserted into mtl_item_revisions table.
1254: In Patchset I, the table were changed to mtl_item_revisions_b and mtl_item_revisions_tl.
1255: In Patchset I, we were constructing insert stmts dymanically to avoid BOM/INV odf dependency.
1256: In Patchset J, we are inserting into the new tables. Dependency will not be an issue because we are maintaining a separate branch for J and I.
1257: Cannot do bulk processing here, since a different revision_id needs to be generated for each config
1258: +-------------------------------------------*/
1259: lStmtNumber := 30;
1260:
1261: FOR v_bcolu_cfg IN c_bcolu_cfg LOOP
1262: --removed as part of bugfix 3340844
1263: /*select MTL_ITEM_REVISIONS_B_S.nextval
1264: into l_rev_id
1265: from dual;*/
1266:
1267:
1264: into l_rev_id
1265: from dual;*/
1266:
1267:
1268: WriteToLog('Going to insert rows into mtl_item_revisions_b:: '|| v_bcolu_cfg.config_item_id,2);
1269: insert into mtl_item_revisions_b
1270: (inventory_item_id,
1271: organization_id,
1272: revision,
1265: from dual;*/
1266:
1267:
1268: WriteToLog('Going to insert rows into mtl_item_revisions_b:: '|| v_bcolu_cfg.config_item_id,2);
1269: insert into mtl_item_revisions_b
1270: (inventory_item_id,
1271: organization_id,
1272: revision,
1273: last_update_date,
1292: gLoginId, -- last_update_login
1293: sysdate,
1294: sysdate,
1295: 1, --would be 1 for initial creation of item
1296: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --l_rev_id, --revision_id is generated from sequence
1297: mp1.starting_revision --3340844
1298: from
1299: mtl_parameters mp1,
1300: mtl_system_items m
1301: where m.inventory_item_id = v_bcolu_cfg.config_item_id
1302: and m.organization_id = mp1.organization_id
1303: and NOT EXISTS
1304: (select NULL
1305: from MTL_ITEM_REVISIONS_B
1306: where inventory_item_id = v_bcolu_cfg.config_item_id
1307: and organization_id = mp1.organization_id);
1308:
1309: WriteToLog('Inserted rows into mtl_item_revisions_b:: '||sql%rowcount,2);
1305: from MTL_ITEM_REVISIONS_B
1306: where inventory_item_id = v_bcolu_cfg.config_item_id
1307: and organization_id = mp1.organization_id);
1308:
1309: WriteToLog('Inserted rows into mtl_item_revisions_b:: '||sql%rowcount,2);
1310: --insert into _tl table so that item is visible in revisions form
1311: --for multi-lingual support
1312:
1313: insert into mtl_item_revisions_tl (
1338: from
1339: mtl_system_items_tl m,
1340: bom_cto_src_orgs bcso,
1341: fnd_languages l,
1342: mtl_item_revisions_b mr --3338108
1343: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id
1344: and bcso.model_item_id = m.inventory_item_id
1345: and bcso.line_id = v_bcolu_cfg.line_id
1346: and m.organization_id = bcso.organization_id