APPS.WSM_MES_UTILITIES_PVT dependencies on WIP_OPERATIONS

Line 391: from wip_operations

387: if ((p_intraop_step IS NULL) OR (p_intraop_step IS NOT NULL AND p_intraop_step = -1)) then --completed op
388: --job needs to be completed and job op should be max
389: select max(operation_seq_num)
390: into l_max_op_seq_num
391: from wip_operations
392: where wip_entity_id = p_wip_entity_id;
393:
394: if (l_max_op_seq_num <> p_job_op_seq_num AND p_status_type <> 4) then
395: x_allowed := 0;

Line 538: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO

534: begin
535: IF (l_routing_op_seq_num IS NOT NULL) THEN
536: SELECT nvl(BOS.use_org_settings, 1), nvl(BOS.run_mandatory_flag, 0), nvl(BOS.to_move_mandatory_flag, 0)
537: INTO l_op_use_org_settings, l_op_run_mandatory_flag, l_op_to_move_mandatory_flag
538: FROM BOM_OPERATION_SEQUENCES BOS, WIP_OPERATIONS WO
539: WHERE WO.wip_entity_id = p_wip_entity_id
540: AND WO.operation_seq_num = p_job_op_seq_num
541: AND BOS.operation_sequence_id = WO.operation_sequence_id;
542: ELSE

Line 545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

541: AND BOS.operation_sequence_id = WO.operation_sequence_id;
542: ELSE
543: SELECT nvl(BSO.use_org_settings, 1), nvl(BSO.run_mandatory_flag, 0), nvl(BSO.to_move_mandatory_flag, 0)
544: INTO l_op_use_org_settings, l_op_run_mandatory_flag, l_op_to_move_mandatory_flag
545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
546: WHERE WO.wip_entity_id = p_wip_entity_id
547: AND WO.operation_seq_num = p_job_op_seq_num
548: AND BSO.standard_operation_id = WO.standard_operation_id
549: AND BSO.organization_id = WO.organization_id;

Line 699: wip_operations WO

695: l_status_type,
696: l_intraop_step
697: from wip_discrete_jobs WDJ,
698: wip_entities WE,
699: wip_operations WO
700: where WE.entity_type in (5, 8)
701: and WDJ.wip_entity_id = we.wip_entity_id
702: and WDJ.organization_id = we.organization_id
703: and WDJ.status_type in (3, 6)

Line 766: wip_operations WO,

762: l_status_type,
763: l_rtg_op_seq_num
764: from wip_discrete_jobs WDJ,
765: wip_entities WE,
766: wip_operations WO,
767: wip_operation_resources WOR,
768: wsm_lot_based_jobs WLBJ
769: where WE.entity_type in (5, 8)
770: and WDJ.wip_entity_id = we.wip_entity_id

Line 809: wip_operations WO,

805: l_status_type,
806: l_rtg_op_seq_num
807: from wip_discrete_jobs WDJ,
808: wip_entities WE,
809: wip_operations WO,
810: wip_operation_resources WOR,
811: wip_op_resource_instances WORI,
812: wsm_lot_based_jobs WLBJ
813: where WE.entity_type in (5, 8)