DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on MTL_ITEM_REVISIONS

Line 177: from WIP_DISCRETE_JOBS wdj, MTL_ITEM_REVISIONS MIR

173: and msi.revision_qty_control_code=2)
174: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
175: and not exists (
176: select 'X'
177: from WIP_DISCRETE_JOBS wdj, MTL_ITEM_REVISIONS MIR
178: where wdj.organization_id = we.organization_id
179: and wdj.wip_entity_id = we.wip_entity_id
180: and mir.organization_id = wdj.organization_id
181: and mir.inventory_item_id = we.primary_item_id

Line 191: from WIP_REPETITIVE_SCHEDULES WRS, MTL_ITEM_REVISIONS MIR

187: ))
188: or (we.entity_type = WIP_CONSTANTS.REPETITIVE
189: and not exists (
190: select 'X'
191: from WIP_REPETITIVE_SCHEDULES WRS, MTL_ITEM_REVISIONS MIR
192: where wrs.organization_id = we.organization_id
193: and wrs.repetitive_schedule_id = p_rep_sched_id
194: and mir.inventory_item_id = we.primary_item_id
195: and mir.organization_id = we.organization_id