DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on MTL_ITEM_REVISIONS

Line 161: from mtl_item_revisions mir

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: )

Line 190: from mtl_item_revisions mir

186: x_bom_rev_exists = 1
187: and exists
188: (
189: select 1
190: from mtl_item_revisions mir
191: where mir.organization_id = mti.organization_id
192: and mir.inventory_item_id = mti.inventory_item_id
193: and mir.revision = mti.bom_revision
194: )

Line 210: same table MTL_ITEM_REVISIONS.

206: /*************************************************
207: Make sure that if both the revision as well as
208: the Bom revision are populated, then they should
209: be the same as both of them are based out of the
210: same table MTL_ITEM_REVISIONS.
211: **************************************************/
212:
213: if (x_bom_rev is not null) and (x_rev is not null)
214: and (x_success =1 ) then