DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_WORK_ORDER_DETAILS_V

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;