DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_INFO dependencies on WIP_SHOP_FLOOR_STATUSES

Line 134: from wip_shop_floor_statuses ws,

130: or
131: wo.repetitive_schedule_id = c_first_schedule_id)
132: and not exists
133: (select 'No move status exists'
134: from wip_shop_floor_statuses ws,
135: wip_shop_floor_status_codes wsc
136: where wsc.organization_id = wo.organization_id
137: and ws.organization_id = wo.organization_id
138: and ws.wip_entity_id = wo.wip_entity_id

Line 185: from wip_shop_floor_statuses ws,

181: or
182: wo.repetitive_schedule_id = c_first_schedule_id)
183: and exists
184: (select 'Move status exists'
185: from wip_shop_floor_statuses ws,
186: wip_shop_floor_status_codes wsc
187: where wsc.organization_id = wo.organization_id
188: and ws.organization_id = wo.organization_id
189: and ws.wip_entity_id = wo.wip_entity_id