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 1243: wip_repetitive_schedules wrs

1239: into l_quantity_in_queue,
1240: l_quantity_running,
1241: l_quantity_completed
1242: from wip_operations wo,
1243: wip_repetitive_schedules wrs
1244: where wo.wip_entity_id = g_ShopFloorMove_rec.wip_entity_id
1245: and wrs.wip_entity_id = wo.wip_entity_id
1246: and wo.organization_id = wrs.organization_id
1247: and wo.repetitive_schedule_id = wrs.repetitive_schedule_id