APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 916: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod

912: --Bug #5350181 :Changed the query to capture pending flag and user defined status
913:
914: SELECT wdj.status_type,ewod.user_defined_status_id,ewod.pending_flag
915: INTO l_wo_status,l_user_defined_status,l_pending_flag
916: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod
917: WHERE wdj.wip_entity_id=p_work_object_id
918: and ewod.wip_entity_id=wdj.wip_entity_id;
919:
920: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;

Line 1042: FROM eam_work_order_details ewod,eam_wo_statuses_v ewsv

1038: AND WSR.RELATIONSHIP_TYPE = 1;
1039:
1040: CURSOR get_status(p_work_object_id NUMBER) IS
1041: SELECT work_order_status
1042: FROM eam_work_order_details ewod,eam_wo_statuses_v ewsv
1043: WHERE ewod.wip_entity_id = p_work_object_id
1044: AND ewod.user_defined_status_id = ewsv.status_id;
1045: BEGIN
1046: