APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on CSI_ITEM_INSTANCES

Line 140: FROM CSI_ITEM_INSTANCES

136:
137: IF l_eam_failure_entry_record.object_type = 1 THEN
138: SELECT COUNT(1)
139: INTO l_valid_object_id
140: FROM CSI_ITEM_INSTANCES
141: WHERE instance_id = l_eam_failure_entry_record.object_id;
142: IF l_valid_object_id = 0 THEN
143: -- Object_id is not a valid maintenace object
144: -- Not a Valid Maintenance Object Id

Line 388: FROM CSI_ITEM_INSTANCES

384: */
385: BEGIN
386: SELECT inventory_item_id
387: INTO l_inventory_item_id
388: FROM CSI_ITEM_INSTANCES
389: WHERE instance_id = ( SELECT object_id FROM eam_asset_failures
390: WHERE failure_id = l_eam_failure_codes_record.failure_id
391: );
392: EXCEPTION

Line 774: FROM CSI_ITEM_INSTANCES

770: BEGIN
771:
772: SELECT inventory_item_id
773: INTO l_inventory_item_id
774: FROM CSI_ITEM_INSTANCES
775: WHERE instance_id = ( SELECT object_id
776: FROM eam_asset_failures
777: WHERE failure_id = l_eam_failure_codes_record.failure_id
778: );