[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
1107:
1108: /*-------------------------------------------+
1109: Insert Item revision information
1110: Till Patchset I, this information was inserted into mtl_item_revisions table.
1111: In Patchset I, the table were changed to mtl_item_revisions_b and mtl_item_revisions_tl.
1112: In Patchset I, we were constructing insert stmts dymanically to avoid BOM/INV odf dependency.
1113: 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.
1114: Cannot do bulk processing here, since a different revision_id needs to be generated for each config
1115: +-------------------------------------------*/
1116: lStmtNumber := 30;
1117:
1118: FOR v_bcolu_cfg IN c_bcolu_cfg LOOP
1119: --removed as part of bugfix 3340844
1120: /*select MTL_ITEM_REVISIONS_B_S.nextval
1121: into l_rev_id
1122: from dual;*/
1123:
1124:
1121: into l_rev_id
1122: from dual;*/
1123:
1124:
1125: WriteToLog('Going to insert rows into mtl_item_revisions_b:: '|| v_bcolu_cfg.config_item_id,2);
1126: insert into mtl_item_revisions_b
1127: (inventory_item_id,
1128: organization_id,
1129: revision,
1122: from dual;*/
1123:
1124:
1125: WriteToLog('Going to insert rows into mtl_item_revisions_b:: '|| v_bcolu_cfg.config_item_id,2);
1126: insert into mtl_item_revisions_b
1127: (inventory_item_id,
1128: organization_id,
1129: revision,
1130: last_update_date,
1149: gLoginId, -- last_update_login
1150: sysdate,
1151: sysdate,
1152: 1, --would be 1 for initial creation of item
1153: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --l_rev_id, --revision_id is generated from sequence
1154: mp1.starting_revision --3340844
1155: from
1156: mtl_parameters mp1,
1157: mtl_system_items m
1158: where m.inventory_item_id = v_bcolu_cfg.config_item_id
1159: and m.organization_id = mp1.organization_id
1160: and NOT EXISTS
1161: (select NULL
1162: from MTL_ITEM_REVISIONS_B
1163: where inventory_item_id = v_bcolu_cfg.config_item_id
1164: and organization_id = mp1.organization_id);
1165:
1166: WriteToLog('Inserted rows into mtl_item_revisions_b:: '||sql%rowcount,2);
1162: from MTL_ITEM_REVISIONS_B
1163: where inventory_item_id = v_bcolu_cfg.config_item_id
1164: and organization_id = mp1.organization_id);
1165:
1166: WriteToLog('Inserted rows into mtl_item_revisions_b:: '||sql%rowcount,2);
1167: --insert into _tl table so that item is visible in revisions form
1168: --for multi-lingual support
1169:
1170: insert into mtl_item_revisions_tl (
1195: from
1196: mtl_system_items_tl m,
1197: bom_cto_src_orgs bcso,
1198: fnd_languages l,
1199: mtl_item_revisions_b mr --3338108
1200: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id
1201: and bcso.model_item_id = m.inventory_item_id
1202: and bcso.line_id = v_bcolu_cfg.line_id
1203: and m.organization_id = bcso.organization_id