APPS.WSM_MES_UTILITIES_PVT dependencies on WIP_ENTITIES

Line 698: wip_entities WE,

694: l_quantity,
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

Line 744: l_job_name wip_entities.wip_entity_name%type;

740: p_resource_id in number,
741: p_instance_id in number,
742: p_serial_number in varchar2) return varchar2
743: is
744: l_job_name wip_entities.wip_entity_name%type;
745: l_wip_entity_id number;
746: l_op_seq_num number;
747: l_rtg_op_seq_num number;
748: l_status_type number;

Line 765: wip_entities WE,

761: l_op_seq_num,
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)

Line 808: wip_entities WE,

804: l_op_seq_num,
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