DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_REPETITIVE_SCHEDULES

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

Line 1291: wip_repetitive_schedules wrs

1287: into l_quantity_in_queue,
1288: l_quantity_running,
1289: l_quantity_completed
1290: from wip_operations wo,
1291: wip_repetitive_schedules wrs
1292: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1293: and wrs.wip_entity_id = wo.wip_entity_id
1294: and wo.organization_id = wrs.organization_id
1295: and wo.repetitive_schedule_id = wrs.repetitive_schedule_id