APPS.EAM_ASSETNUMBER_PUB dependencies on WIP_DISCRETE_JOBS
Line 904: FROM wip_discrete_jobs wdj
900: SELECT 1 INTO l_count
901: FROM DUAL
902: WHERE EXISTS
903: (SELECT wdj.wip_entity_id 904: FROM wip_discrete_jobs wdj 905: WHERE wdj.status_type not in (4, 5, 7, 12)
906: AND wdj.maintenance_object_id = l_instance_id
907: AND wdj.maintenance_object_type = 3
908: AND wdj.organization_id = l_org)