APPS.EAM_WO_DEFAULT_PVT dependencies on CSI_ITEM_INSTANCES

Line 655: csi_item_instances cii,

651: INTO
652: l_priority
653: , l_owning_department
654: FROM
655: csi_item_instances cii,
656: eam_org_maint_defaults eomd
657: WHERE
658: cii.instance_id = p_eam_wo_rec.maintenance_object_id
659: and eomd.object_type (+) = 50

Line 984: from csi_item_instances cii, mtl_system_items msi

980: , msi.eam_item_type
981: into l_serial_number
982: , l_inventory_item_id
983: , l_eam_item_type
984: from csi_item_instances cii, mtl_system_items msi
985: where cii.last_vld_organization_id = msi.organization_id
986: and cii.inventory_item_id = msi.inventory_item_id
987: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
988: