DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 1644: wip_shop_floor_status_codes wsc

1640: AND wo.repetitive_schedule_id is NULL
1641: AND not exists
1642: (select 'No move status exists'
1643: from wip_shop_floor_statuses ws,
1644: wip_shop_floor_status_codes wsc
1645: where wsc.organization_id = wo.organization_id
1646: and ws.organization_id = wo.organization_id
1647: and ws.wip_entity_id = wo.wip_entity_id
1648: and ws.line_id is NULL

Line 1672: wip_shop_floor_status_codes wsc

1668: AND wo.repetitive_schedule_id is NULL
1669: AND exists
1670: (select 'Move status exists'
1671: from wip_shop_floor_statuses ws,
1672: wip_shop_floor_status_codes wsc
1673: where wsc.organization_id = wo.organization_id
1674: and ws.organization_id = wo.organization_id
1675: and ws.wip_entity_id = wo.wip_entity_id
1676: and ws.line_id is NULL