DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_INFO dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 135: wip_shop_floor_status_codes wsc

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
139: and (ws.line_id is NULL

Line 186: wip_shop_floor_status_codes wsc

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
190: and (ws.line_id is NULL