APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_REVISIONS_B

Line 184: | insert into MTL_ITEM_REVISIONS was changed to MTL_ITEM_REVISIONS_B

180: inventory from 11.5.9 onwards
181: |
182: |
183: | 12-31-2002 Kiran Konada bugfix2730055
184: | insert into MTL_ITEM_REVISIONS was changed to MTL_ITEM_REVISIONS_B
185: |
186: |
187: | 01-23-2003 Kundan Sarkar Bugfix 2503104
188: | Revert fix as OM will populate user_item_description

Line 243: | of mtl_item_revisions_b

239: |
240: | 30-DEC-2003 Kiran Konada Bugfix
241: | 3340844
242: | inserted value into revision_label
243: | of mtl_item_revisions_b
244: |
245: | 3338108
246: | a) In 11.5.9 in the dynamic sql part
247: | of inserting into mtl_item_revisions_b

Line 247: | of inserting into mtl_item_revisions_b

243: | of mtl_item_revisions_b
244: |
245: | 3338108
246: | a) In 11.5.9 in the dynamic sql part
247: | of inserting into mtl_item_revisions_b
248: | we were inserting same revision_id for
249: | an item in all orgs. Revision_id was a
250: | null column
251: |

Line 258: | info from table mtl_item_revisions_b table

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
261: | it is decided to leave blank the uom_code and revision_id
262: | in mtl_cross_references

Line 8967: --sql_stmt := 'SELECT MTL_ITEM_REVISIONS_B_S.nextval FROM dual';

8963:
8964: IF PG_DEBUG <> 0 THEN --Bugfix 6063990
8965: oe_debug_pub.add('Inside populate_item_revision');
8966: END IF;
8967: --sql_stmt := 'SELECT MTL_ITEM_REVISIONS_B_S.nextval FROM dual';
8968:
8969: --IF PG_DEBUG <> 0 THEN
8970: -- oe_debug_pub.add(sql_stmt,3);
8971: --END IF;

Line 8987: insert into mtl_item_revisions_b

8983: we are assuming that customers will always be on ITEMS 11.5.10 data model i.e. they will have tables _B and _TL.
8984: So changing dynamic sql into static sql */
8985:
8986: --sql_stmt :=
8987: insert into mtl_item_revisions_b
8988: (inventory_item_id,
8989: organization_id,
8990: revision,
8991: last_update_date,

Line 9014: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --:x_item_rev_seq --revision_id is generated from sequence

9010: gLoginId, -- last_update_login
9011: sysdate,
9012: sysdate,
9013: 1, --would be 1 for initial creation of item
9014: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --:x_item_rev_seq --revision_id is generated from sequence
9015: mp1.starting_revision --3340844
9016: from
9017: mtl_parameters mp1,
9018: mtl_system_items m

Line 9023: from MTL_ITEM_REVISIONS_B

9019: where m.inventory_item_id = pConfigId
9020: and m.organization_id = mp1.organization_id
9021: and NOT EXISTS
9022: (select NULL
9023: from MTL_ITEM_REVISIONS_B
9024: where inventory_item_id = pConfigId
9025: and organization_id = mp1.organization_id);
9026:
9027:

Line 9038: oe_debug_pub.add('Inserted into mtl_item_revisions_b for item ' || pConfigId || ' rows ' || SQL%ROWCOUNT );

9034: --EXECUTE IMMEDIATE sql_stmt USING pConfigId, gUserId, gUserId, gLoginId,pModelId, pLineId, pConfigId;
9035: --EXECUTE IMMEDIATE sql_stmt USING pConfigId, gUserId, gUserId, gLoginId,pConfigId,pConfigId; Bugfix 6063990
9036:
9037: IF PG_DEBUG <> 0 THEN
9038: oe_debug_pub.add('Inserted into mtl_item_revisions_b for item ' || pConfigId || ' rows ' || SQL%ROWCOUNT );
9039: END IF;
9040:
9041:
9042:

Line 9079: mtl_item_revisions_b mr, --3338108

9075: mtl_parameters mp1,
9076: mtl_system_items_tl m,
9077: bom_cto_src_orgs bcso,
9078: fnd_languages l,
9079: mtl_item_revisions_b mr, --3338108
9080: mtl_parameters mp2 --4109427
9081: where m.inventory_item_id = pModelId
9082: and bcso.model_item_id = m.inventory_item_id
9083: and bcso.line_id = pLineId