157: msi.revision_qty_control_code = 2
158: and exists
159: (
160: select 1
161: from mtl_item_revisions mir
162: where mir.organization_id = mti.organization_id
163: and mir.inventory_item_id = mti.inventory_item_id
164: and mir.revision = mti.revision
165: )
185: x_bom_rev_exists = 1
186: and exists
187: (
188: select 1
189: from mtl_item_revisions mir
190: where mir.organization_id = mti.organization_id
191: and mir.inventory_item_id = mti.inventory_item_id
192: and mir.revision = mti.bom_revision
193: )
205: /*************************************************
206: Make sure that if both the revision as well as
207: the Bom revision are populated, then they should
208: be the same as both of them are based out of the
209: same table MTL_ITEM_REVISIONS.
210: **************************************************/
211:
212: if (x_bom_rev is not null) and (x_rev is not null)
213: and (x_success =1 ) then