DBA Data[Home] [Help]

APPS.WMA_MOVE dependencies on WIP_SHOP_FLOOR_STATUSES

Line 1318: wip_shop_floor_statuses ws

1314: -- Fixed bug 5252677. Check no move shopfloor status at from step.
1315: SELECT count(*)
1316: INTO l_noMoveCount
1317: FROM wip_shop_floor_status_codes wsc,
1318: wip_shop_floor_statuses ws
1319: WHERE wsc.organization_id = p_orgID
1320: AND ws.organization_id = wsc.organization_id
1321: AND ws.wip_entity_id = p_jobID
1322: AND ws.operation_seq_num = p_fmOp