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 189: from mtl_item_revisions mir

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

Line 209: same table MTL_ITEM_REVISIONS.

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