DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_SHOP_FLOOR_STATUSES

Line 1848: from wip_shop_floor_statuses ws,

1844: AND wo.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id
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

Line 1876: from wip_shop_floor_statuses ws,

1872: AND wo.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id
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