APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on WIP_DISCRETE_JOBS

Line 119: FROM csi_item_instances cii, wip_discrete_jobs wdj

115: AND (end_date_active is NULL OR sysdate <= end_date_active);
116:
117: CURSOR get_asset_number(p_wip_entity_id NUMBER) IS
118: SELECT instance_number
119: FROM csi_item_instances cii, wip_discrete_jobs wdj
120: WHERE decode(wdj.maintenance_object_type,3, wdj.maintenance_object_id,NULL) = cii.instance_id(+)
121: AND wdj.wip_entity_id = p_wip_entity_id;
122:
123: l_is_revision_control BOOLEAN;