DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 1849: wip_shop_floor_status_codes wsc

1845: AND wo.repetitive_schedule_id is NULL
1846: AND not exists
1847: (select 'No move status exists'
1848: from wip_shop_floor_statuses ws,
1849: wip_shop_floor_status_codes wsc
1850: where wsc.organization_id = wo.organization_id
1851: and ws.organization_id = wo.organization_id
1852: and ws.wip_entity_id = wo.wip_entity_id
1853: and ws.line_id is NULL

Line 1877: wip_shop_floor_status_codes wsc

1873: AND wo.repetitive_schedule_id is NULL
1874: AND exists
1875: (select 'Move status exists'
1876: from wip_shop_floor_statuses ws,
1877: wip_shop_floor_status_codes wsc
1878: where wsc.organization_id = wo.organization_id
1879: and ws.organization_id = wo.organization_id
1880: and ws.wip_entity_id = wo.wip_entity_id
1881: and ws.line_id is NULL