DBA Data[Home] [Help]

APPS.EAM_ASSETNUMBER_PUB dependencies on WIP_DISCRETE_JOBS

Line 872: FROM wip_discrete_jobs wdj

868: SELECT 1 INTO l_count
869: FROM DUAL
870: WHERE EXISTS
871: (SELECT wdj.wip_entity_id
872: FROM wip_discrete_jobs wdj
873: WHERE wdj.status_type not in (4, 5, 7, 12)
874: AND wdj.maintenance_object_id = l_instance_id
875: AND wdj.maintenance_object_type = 3
876: AND wdj.organization_id = l_org)