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 770: FROM CSI_ITEM_INSTANCES

766: BEGIN
767:
768: SELECT inventory_item_id
769: INTO l_inventory_item_id
770: FROM CSI_ITEM_INSTANCES
771: WHERE instance_id = ( SELECT object_id
772: FROM eam_asset_failures
773: WHERE failure_id = l_eam_failure_codes_record.failure_id
774: );