DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 932: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod

928: --Bug #5350181 :Changed the query to capture pending flag and user defined status
929: BEGIN
930: SELECT wdj.status_type,ewod.user_defined_status_id,ewod.pending_flag
931: INTO l_wo_status,l_user_defined_status,l_pending_flag
932: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod
933: WHERE wdj.wip_entity_id=p_work_object_id
934: and ewod.wip_entity_id=wdj.wip_entity_id;
935: EXCEPTION -- added exception for bug 13736177
936: WHEN NO_DATA_FOUND THEN

Line 1065: FROM eam_work_order_details ewod,eam_wo_statuses_v ewsv

1061: AND WSR.RELATIONSHIP_TYPE = 1;
1062:
1063: CURSOR get_status(p_work_object_id NUMBER) IS
1064: SELECT work_order_status
1065: FROM eam_work_order_details ewod,eam_wo_statuses_v ewsv
1066: WHERE ewod.wip_entity_id = p_work_object_id
1067: AND ewod.user_defined_status_id = ewsv.status_id;
1068: BEGIN
1069: