DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_SHOP_FLOOR_STATUSES

Line 897: from wip_shop_floor_statuses s, wip_shop_floor_status_codes c

893:
894: Begin
895: select count(*), min(s.intraoperation_step_type), max(s.intraoperation_step_type)
896: into l_num_shop_status, l_nomove_step_min, l_nomove_step_max
897: from wip_shop_floor_statuses s, wip_shop_floor_status_codes c
898: where s.wip_entity_id = p_wip_entity_id and
899: s.operation_seq_num = p_op_seq_num and
900: s.shop_floor_status_code = c.shop_floor_status_code and
901: s.organization_id = c.organization_id and