APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on WIP_DISCRETE_JOBS

Line 123: FROM csi_item_instances cii, wip_discrete_jobs wdj

119: AND (end_date_active is NULL OR sysdate <= end_date_active);
120:
121: CURSOR get_asset_number(p_wip_entity_id NUMBER) IS
122: SELECT escapeXMLEam(instance_number) instance_number --for bugfix 10192902
123: FROM csi_item_instances cii, wip_discrete_jobs wdj
124: WHERE decode(wdj.maintenance_object_type,3, wdj.maintenance_object_id,NULL) = cii.instance_id(+)
125: AND wdj.wip_entity_id = p_wip_entity_id;
126:
127: l_is_revision_control BOOLEAN;