APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on CSI_ITEM_INSTANCES

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;

Line 139: l_asset_number csi_item_instances.instance_number%TYPE;

135: l_api_version CONSTANT NUMBER:=1;
136: l_api_name VARCHAR2(100);
137: l_unexpected_excep EXCEPTION;
138: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
139: l_asset_number csi_item_instances.instance_number%TYPE;
140: l_yes_no mfg_lookups.meaning%TYPE;
141: BEGIN
142: l_asset_sub_only := FALSE;
143: l_api_name :='Check_Shortage';